Check box checked if there is data in a field

  • Thread starter Thread starter BZeyger
  • Start date Start date
B

BZeyger

Hello,

I have an Access VBA database that has multiple tables and forms. One of the
forms has a detail section which lists all of my records. Two fields refer to
two different file locations. They are text fields.

Textbox Datafield Table name

txtLocation Location Info

I wanted to make the txtLocation button invisible.
In its place, I wanted a check box.

chk1

I wanted to have the check box checked off if there was data in the Location
field.

How would I do this? I did not know the code to assign the check box.
 
How about the following:

me.checkbox=not isnull(me.txtLocation)

and then you'd have to replace the names for the actual controlnames you are
using.

hth
 
Back
Top