By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 2,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

#Error on form when no data present: Access 2003...

Dököll
Expert 100+
P: 2,364
Hey Fans!

Perhaps you can help me...

I am using MS Access 2003. I have tried a number of things to get rid of the text #Error from appearing on form fields when no data present.

Tried the NZ function, also tried the IIF function, told it to give me zero if no data found, so far it seems to lead to nowhere land. What are your thoughts? Hopefully it's not very simple and I missed the boat, hee hee...

Thanks for your help!

Dököll
Mar 7 '08 #1
Share this Question
Share on Google+
5 Replies


P: 59
sounds like there is a problem with your form fields. Fields should appear empty if there is no data in the underlying table/query/expression.

#error/#name etc. in the field would suggest there is a problem in retreiving the value, not that the value is null
Mar 7 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
While that's true of #Name, it's on ly sometimes true of #Error! With #Error it can also mean that the expression used as ControlSource cannaot be evaluated. What's the expression you have in the ControlSource for this field?

Linq ;0)>
Mar 7 '08 #3

P: 59
While that's true of #Name, it's on ly sometimes true of #Error! With #Error it can also mean that the expression used as ControlSource cannaot be evaluated. What's the expression you have in the ControlSource for this field?

Linq ;0)>
thanks missinglinq you are right it is most likely a prob with the fields controlsource expression, nice call:)
Mar 7 '08 #4

NeoPa
Expert Mod 15k+
P: 31,494
Tell us what you are populating the fields with in your form.
Include the details for a control where this happens as well as the RecordSource of the form itself if you can.
Mar 10 '08 #5

Dököll
Expert 100+
P: 2,364
Hey Gang!

Thanks for replying and please excuse the late reply. The form is being populated by a subform which is being populated by a query, will post some of the work to get an idea:

This is one of the fields that have the #Error instance

Expand|Select|Wrap|Line Numbers
  1.  
  2. =[InfoOnlyDataPRE].Form!InfoInfo
  3.  
  4.  
This is the subform portion, an attempt to calculate all items within that column/field abd feed it to the form using =[InfoOnlyDataPRE].Form!InfoInfo

Expand|Select|Wrap|Line Numbers
  1.  
  2. =Sum(NZ([Informational]))
  3.  
  4.  
This is our query portion, an attempt to feed items to subform column/field

Expand|Select|Wrap|Line Numbers
  1.  
  2. Informational: IIf(NZ([DataCentralReport!Category]="PreErrors" And [DataCentralReport!Informational])=True,1,0)
  3.  
  4.  
It looks like it should work, I should get zero, don't you think? When data are available as mentioned, all is well. Something is there, and I just can't quite put my finger on it.

Let me kow what you see. And thanks for your assistance, very cool.

Dököll
Mar 27 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.