Solved

VB Grid & Access

Posted on 1998-12-16
2
127 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
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…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now