Use check box to populate a text box

  • Thread starter Thread starter Bill Davis
  • Start date Start date
B

Bill Davis

I have a check box on my form and when it is check i want
to display "Pending" in the text box below it and display
it in red. Is this possible?
Thanks in advance
 
Bill

In the AfterUpdate event of the checkbox, add code that sets the text and
color of your text message.

It would look something like (actual syntax may vary):

If Me!chkMyCheckBox = True Then
Me!txtMyTextMessage = "Pending"
Me!txtMyTextMessage.ForeColor = vbRed
ElseIf Me!chkMyCheckBox = False Then
Me!txtMyTextMessage = ""
Else
'handle this error
End If

Good luck!

Jeff Boyce
<Access MVP>
 
Jeff,
When a box is check it displays Pending for all the
records and when i remove the check it removed it from
all records. Any ideal of what I am doing wrong?
Bill
 
The checkbox control source should be a part of your underlying table.

Damon
 
Bill

Are you working with a datasheet view? Is (as Damon asks) the checkbox
unbound or bound?
 
It is a bound to the main table, that is why i dont
understand why it is not working..
 
Lou

Please re-read my previous post -- are you using a single-form or datasheet
view?
 
You must log in or register to reply here.

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

Need combo box to refresh when moving to new record 2017 1
I want Combo box to be populated depending on customer category 11
formating an unbound text box 1
Hello happy new year to all, Text box input for year of purchase 0
Why isn't my text box/label populating on the report 3
Call form from text field and populate combo box. 1
check box to update text box 10
Change font color from a check box 1

Back
Top