enter YES when text box empty

  • Thread starter Thread starter Norm
  • Start date Start date
N

Norm

I want YES to show on the report when the text box linked to AS400 is empty
and NO when the box is populated, the report information is from a query
 
Norm,
Use the On Format event of the report section where the AS400
text control is located. (ex. OnFormat for DetailSection)I'll assume by... AS400 "empty"... you mean Null.

Locate an unbound text control named AS400YesNo in that same section.
Set the ControlSource to...
=IIF(IsNull(AS400), "Yes","No")
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top