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!

You have entered expression that has no value

Status
Not open for further replies.
rafal444

rafal444

Programmer
Aug 11, 2006
74
US
I am getting this error. How to test for it?

I have tried for IsNUll(Value), is error(value) isempty(Value)

All returns False! How to check for this error???
 
Sort by date Sort by votes
How are ya rafal444 . . .

Whats the source of [purple]Value[/purple]?

Perhaps [blue]Me!TextboxName[/blue].Value

[blue]Your Thoughts? . . .[/blue]

Calvin.gif
See Ya! . . . . . .
 
Upvote 0 Downvote
Value is a calculated field on the report. =NullToZero([my query field])
 
Upvote 0 Downvote
rafal444 . . .

Can't say unless you post the function [blue]NullToZero[/blue]!

Calvin.gif
See Ya! . . . . . .
 
Upvote 0 Downvote
The name of the function suggests to me that the following can be used instead:
Code: 
=nz([my query field],0)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
1K
dhookom
dhookom
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
417
dhookom
dhookom
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
807
JanaLNelson
JanaLNelson
qqp
  • Locked
  • Question
Looking for ideas on how to create an estimating form that would have a header and details under it 1
Replies
2
Views
156
qqp
qqp
PLCBeetle
  • Locked
  • Question
Passing a form value to query...
Replies
6
Views
153
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top