enter YES when text box empty

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
 
A

Al Campagna

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

Content Control Box Issue - Please Help! 0
Link a text box based on drop down box with four options MS Word 365 0
Shared Link is showing empty notebook 1
Split form 0
Program buttons to create a word document 0
AppleScript - How do I select a text ? 1
Word OLE to check spelling in text box 1
Newbie Help - IF Yes No Function 0

Top