If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Each patient can have more than one form, however the main problem is each form requires it's own table. So I end up with a lot of blank space because I have a seperate text field for every patients form.

Ex. PatientID - Patient Name
Form1 Import Date ExportDate ...

Form3 Import Date ExportDate ...

and so on...Is there a way to specify to omit (or program in VB) the null text fields in Form2 and bring Form3 up to make formatting cleaner?

woops

Sorry I did not explain correctly, the forms are actually text BOXES which are in descending order order from 1 to 11. The actual text appears blank if it tis a null value but leaves a space causing a lot of unwanted whitespace.