Line under fields that are blank

[Simon]

When i create a report to print out to send to customer is there a way
if a field is null ( eg Phone number) there is a way to get the blank
box to be underlined so it shows the cusomer where to fill out any of
the missing boxes

I do not want any lines under the box if it has been field out on the
database, just the missing fields for customer to fill out


Thanks

 

[Jeff Boyce]

Simon

One (related) approach would be to set the border to show on those controls
without values -- but this sets the entire border, not the "underline".

You could create code to do this in the OnFormat event of the report. You'd
have the code inspect each (text) control for a value, and turn on the
border for any control without a value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rick B]

Replace the control source with something like the following:

=Nz([PhoneNumber],"_________________")