Blank Controls

N

newsgroups

Can you make all blanks controls on a report show "N\A" when a report opens.
These controls have no data at all and the controls are text boxes.
 
A

Al Camp

If you had a field in your table and on the report called, for example,
Hobbies... then Name that field txtHobbies, and give it a ControlSource
of...
= IIF(Is Null([Hobbies]), "N/A", [Hobbies])
(Never Name a calculated field... like this.. the name of a legitimate
field in the recordset.)

This will display "N/A" if Hobbies Is Null.
 
J

John Spencer

You can use the format property to show "N\A" if the controls are null.
For text, set the format property to
Format: @;"N\A"

For numbers and dates, you can use a similar technique. For further
information, open the report in design view, put the cursor into a control's
format property and press F1
 
J

John Spencer

Well,
All I can say is that everyday I learn something new about Access when I am
on these forums.
 
Top