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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can grow text box 20
Text box incomplete in GroupFooter 0
Auto Populated fields from a form 2
text box control source 2
Report, Combo Box 1
Shrinkable Label 3
Growing Textbox Formatting 1
Access MS access forms list box problems 1

Back
Top