Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    5

    Question Unanswered: Change fore color on form based on field content??

    I have a subform that is viewed as a continuous form. I want to set the fore color of one field to red if it contains the code "E". Otherwise, the fore color will be black.

    I've tried to do this in VB on the Form Load Event. Should I try AfterUpdate on the field??

    Thanks in advance for your help!

    JJ

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    You can try afterupdate on the sub form or on current on the Main form.

    Just remeber if you change the fore colour of a textbox on a continuous Form all the textboxes of that field's fore clour will change not just the record you are working with
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

Posting Permissions

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