Null Value

J

JM

If I am using option groups, how can I code one answer on
a multiple choice list to equal "null value" if this box
is checked?
 
V

Van T. Dinh

Each OptionButton / CheckBox in an OptionGroup has a
unique value in the OptionGroup and the Value of the
OptionGroup is the Value of the checked OptionButton /
CheckBox.

Simply use code in the OptionGroup_AfterUpdate Event to
assign Null to whatever if the "Null" option is selected.

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching literal text "???" in Word 2010 field code IF statement 2
How to make repeating drop-down lists? 2
ASK Field Formatting 1
Calculate the median value before a specified list 0
VSTO C# add in Outlook.Appointment error 0
Calculations with possible null value fields 1
VBA Coding Help for Beginner 0
Missing start up options in Word 0

Top