Automatic CheckBox

[mela127]

I am fairly new to Access, but I am working as a student intern in a database management office this summer. So I have been getting better at it more recently. So bear with me if I'm not using the correct terminology or not making sense.

I am working on a database and I have run into a problem that I need some help with. I have a form where the values can be edited or cleared. I also have an activity variable that has a Yes/No property. What I want to happen is when there is a value present in a certain field, I want the activity to be Yes (checked). But when the entry is null, I want the check box to become unchecked (No).

I'd appreciate any help with this. If I'm not being specific enough, just let me know what other information you may need to help me out. Thanks


-Marie

 

[maxmangion]

you can try:

If Not IsNull(Me.FieldName) Then
Me.CheckboxName = True
Else 
Me.ChecboxName = False
End If

 

[mela127]

Sweet deal. Thanks so much. I'm hoping to get better at the whole Visual Basic language. I've only learned it last week, but I'm excited to get better at it!


-Marie

 

[maxmangion]

you're welcome