Null Value

  • Thread starter Thread starter Anthony Persaud
  • Start date Start date
A

Anthony Persaud

How do I resolve:
"Invalid use of Null"

I am trying to pull a debtors report but I get the above
message.
Thanks for you help.
 
Try using the NZ function on what's causing the problem.
If you're assigning a textbox value to a variable and the
value is null try adding "& vbNullstring"
Good luck,
Geof.
 
How do I resolve:
"Invalid use of Null"

I am trying to pull a debtors report but I get the above
message.
Thanks for you help.
Click to expand...

Care to post your code, or your query, or the Control Source of the
textbox or other control which is generating the error? It's a bit
hard to guess where your problem might lie without a little bit of
information about what you're doing!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
I have experienced the same error this week. the problem may be in the
database itsef. I have a query that work in a more recently developed db,
but when the query was copied into an older db this error occured. I am in
the process of creatin a new db. good luck.
 
problem maybe with the db instead of the query. I have a query that will
work in a more recently created db, but an error occurs when the
query/criteria is copied to an older one. good luck
 
Back
Top