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

Populate a table based on check box status 2
Word OLE to check spelling in text box 1
Dialog box that lets the user select the location of a file and st 8
Link a text box based on drop down box with four options MS Word 365 0
Have a dialog box link a file loction to a textbox 1
Creating a Search using a combo box and then creating a report. 4
Possible to Combine reports to's to a single box? 0
Check Box query issue 3

Top