Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    95

    Unanswered: Make Label Visible On Event

    I have a form with a subform that is used for data entry.

    I have two labels on the main form, Label1 and Label2.

    Both of these labels have their visibility set to No.

    I need each label to appear only when a user is entering new information and when the user gets to the % field, if they enter a percent >34%, Label1 is now visible, if the % is bettween 15% and 34%, Label2 is now visible.

    I am assuming this needs to be coding placed in the After Update event.

    If anybody can help me with this, I would greatly appreciate it as I have no previous knowledge on coding and how to approach this.

    Thanks,
    CT

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so you would need to recognise when the user enters the % symbol
    that means examining the controls on change event....
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2009
    Posts
    95
    ok, would you be able to help me with the coding for this?

    Thanks,
    CT

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    would you beable to make an effort to do this yourself?

    in the controls on change event place some code whch examines the character just typed (so it coudl be in the controls on key press event

    personally I think you woudl be better calling a function which checks the value.. if fact waht is wrong with the function supplied to you yesterday? yes it may need tweaking it may need tunign to match exactly what you are after.. but IIRC its basically there or thereabouts
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2009
    Posts
    95
    I have been making attempts at doing this all day yesterday and today. I have zero previous knowledge in coding and the example you helped me with yesterday was like me reading chinese, I have no idea how to change it, where to put it, and how to make it work.

    I am simply looking for advice, direction, and aid.

    Would you be able describe to me how to set up code to examine the character just typed, or how to call a function that checks value?

Posting Permissions

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