Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    1

    Unanswered: Continuous Form Help

    I'm fairly new to VBA and Access, though I'm an experienced C programmer. So I'm stumbling along a bit. I hope I can explain my problem sufficiently...

    I have a continuous form which pulls data from a table. Most of the data is in text boxes with several check boxes.

    Depending on the state of the check boxes, I want to change the color of something in the record based on the state of the check boxes (ForeColor or BackColor of the controls, or the background color of the record would be fine). This is a visual cue that tells me the status of the record at a glance.

    I did find some code that would color all the text on the form one color, but that doesn't exactly fit the bill. I need to be able to access the individual check boxes to test them and the color properties of the record or the color properties on each control in each record.

    Can anybody help?

    Thank you,
    Bill

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Hi,

    See the link below:
    http://www.mvps.org/access/forms/frm0024.htm

    Igor

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •