Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the value of a check box if cheched

Status
Not open for further replies.

ViperD

IS-IT--Management
May 1, 2003
27
0
0
US
I am trying to write an if statement to test the value of a check box (Billed). Here is the code:

If Me.CDG_Billed_ Then 'if CDG_Billed? (Please note that the column name is CDG Billed?)
...

But this does not seem to catch the value of the check box. I've also tried If Me.Billes = "Yes", "Y" and 'y' (seperately of course). I've also tried changing the name of the column to not have the ?. But this did not work as well.
 
If me.CDG_Billed=true then
'insert code
end if

or

If me.CDG_billed.value=true then
'insert code
end if

or
If me.txtnameoftextbox.value then
'insert code
end if

All are the same thing

Hope this helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top