Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    Unanswered: Auto message in a text field

    Hi there,
    I have two text fields in a MS Access form. Now, if I enter <= 5 in the text field #1 , the second text field (text field#2) should show a string "OK" ; but if the value I enter in the tex#1 is >5 , the text#2 should show the string "Not OK".
    How can I do this in a ms access form?
    Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Auto message in a text field

    Originally posted by chandan
    Hi there,
    I have two text fields in a MS Access form. Now, if I enter <= 5 in the text field #1 , the second text field (text field#2) should show a string "OK" ; but if the value I enter in the tex#1 is >5 , the text#2 should show the string "Not OK".
    How can I do this in a ms access form?
    Thanks.
    in the On_EXIT event of the first TextBox write

    &nbsp;if text1 <= 5 then
    &nbsp;&nbsp;&nbsp; text2 = "Ok"
    &nbsp;else
    &nbsp;&nbsp;&nbsp; text2="Not Ok"
    &nbsp;endif

  3. #3
    Join Date
    Jan 2004
    Posts
    5

    Talking

    It Works fine!
    Thanks.
    Chandan

Posting Permissions

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