Line under fields that are blank

  • Thread starter Thread starter Simon
  • Start date Start date
S

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
 
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
 
Replace the control source with something like the following:

=Nz([PhoneNumber],"_________________")
 
Back
Top