Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

text box null

Status
Not open for further replies.
gsanders32

gsanders32

Technical User
May 23, 2007
6
US
I have a report that takes the value of the text box an returns a different value, Ex:(text box county) value is 1 it will return Lubbock. This works great but sometime the value of the text box is null. When this happens all the information for that record will not show in the report.

Is there a way to have the report ignore the null
 
Sort by date Sort by votes
Forgot i need the Txt box to still show on the report even if it is null
 
Upvote 0 Downvote
how's about using the NZ function?

--------------------
Procrastinate Now!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
212
dhookom
dhookom
breezett93
  • Locked
  • Question
Text cut off even though the text box is large enough
Replies
16
Views
735
strongm
strongm
caykamanj1966
  • Locked
  • Question
Search by Date and Some Text
Replies
9
Views
194
dhookom
dhookom
lameid
  • Locked
  • Question
URL Black Rich Text
Replies
0
Views
167
lameid
lameid
iamchemist
  • Locked
  • Question
Write a value into an unbound text box in a Report
Replies
3
Views
152
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top