VB Grid & Access

I use a dbgrid populated by SQL statements extracting data from an Access database. My datatypes are set to currency and I would like to have the default value set to null so if there is no value a blank will appear in the grid cell.  With this there is a problem because you can not add a null field. Any suggestions. Please help.  Thanks
Who is Participating?
kswinneyConnect With a Mentor Commented:
Use the IIF function to return your field value like this:

IIF(MyCurrencyField Is Null, MyCurrencyField, 0)

robhasAuthor Commented:
It put me on the right track.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.