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

how to make a field null in access

P: 1
how to make a field null in access
Aug 28 '09 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
You don't give us enough to go on in what you have posted - please note that we cannot do much to advise you if you take so little care over what you ask.

Short answer to your very short question is to set the field (or control on a form if that is what you really mean) to the value defined by the reserved keyword Null. Nulls are not really values - they represent the absence of a value, not its presence.

Example:

Expand|Select|Wrap|Line Numbers
  1. Private Sub SomeCombo_AfterUpdate()
  2.     If Me.SomeCombo = TriggerValue then
  3.         Me.AnotherControl = Null
  4.     end if
  5. End Sub
Setting fields to null can be done similarly in SQL if you are using an Update query.

-Stewart
Aug 28 '09 #2

Post your reply

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