Solved

VB Grid & Access

Posted on 1998-12-16
2
129 Views
Last Modified: 2010-05-03
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
0
Comment
Question by:robhas
2 Comments
 
LVL 2

Accepted Solution

by:
kswinney earned 70 total points
ID: 1450531
Use the IIF function to return your field value like this:

IIF(MyCurrencyField Is Null, MyCurrencyField, 0)

HTH.
0
 

Author Comment

by:robhas
ID: 1450532
It put me on the right track.
0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA error replacing data 6 40
Microsoft Access combo box help 2 47
Crystal reports - Formula Field code need assistance with code 17 75
Excel Automation VBA 19 74
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question