alternate text if blank record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi folks,

I'm producing registers for events. Report includes company name and delegate name.

Some (actually most!) of the time, we don't have the delegate name, and we need it to produce paperwork at the end of the course. I want to produce a small label to ask them to fill in the blank name space.

I'd like to have a label the same size as the name field, which is visible if the name field is blank. If there's a name, don't see the reminder.

I can do my if's, but can't work this one out? I bet it's something simple!

Thanks in advance,

Piers
 
Piers said:
Hi folks,

I'm producing registers for events. Report includes company name and delegate name.

Some (actually most!) of the time, we don't have the delegate name, and
we need it to produce paperwork at the end of the course. I want to
produce a small label to ask them to fill in the blank name space.

I'd like to have a label the same size as the name field, which is
visible if the name field is blank. If there's a name, don't see the
reminder.

I can do my if's, but can't work this one out? I bet it's something simple!

Thanks in advance,

Piers
Click to expand...

Piers,
You wish to do this on a report, not on a form?

In the report, instead of using the control [DelegateName], use and
unbound control.

Set it's control source to:
=Nz([DelegateName],"Get the guys name!!")

If you wish you can also use IIF().

=IIf(IsNull([DelegateName],"Get the guys name!!",[DelegateName])
 
Back
Top