Check box checked if there is data in a field

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.
 
M

Maurice

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
 

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

Dialog box that lets the user select the location of a file and st 8
Have a dialog box link a file loction to a textbox 1
check box - check all 1
Disable recordset if check box true 1
Check box teaser 2
Form Question - Duplicating fields if check box is checked 1
check box is checked if value of textbox appears in another table 3
If "yes" then require data in another field 3

Top