Blank Controls

  • Thread starter Thread starter newsgroups
  • Start date Start date
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.
 
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.
 
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
 
Well,
All I can say is that everyday I learn something new about Access when I am
on these forums.
 
Back
Top