friendly looking reports

[notaloser]

hey, i have a form that is going to display the information for medical patients all on one page.

i want to know how to display the information without empty space in between like fields fname and lname etc. is there any way to display different columns, for example both fname and lname, in 1 text box to elminate the whitespace?

 

[pbaldy]

Easily done. The term you want to search on is "concatentate" or perhaps "concatenation operator".

 

[notaloser]

thanks, i found some useful threads.

i have some more though.

how do i go about displaying a message (such as "No Medications Prescribed" for a patient that does not have any medications) instead of just whitespace?

AND

how do i get the report to omit an entire line of whitespace if none of the fields displayed on that line exist? is there a way to move the rest of the report up 1 line to omit that whitespace?

 

[pbaldy]

You can play with the Can Grow/Can Shrink properties of the textboxes, but I have to say that the question indicates the possibility of a normalization issue. It sounds like medications should be stored in a separate table and displayed in a subreport. I'd be curious what your table structure is.

 

[notaloser]

that is how it is set up, i have multiple tables, general, referring doctors, appointments, medications, etc, all linked by a unique history number ill play with the subreports a little bit