Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: Adding characters to a form text field "on exit"

    Hi, I have an email text field and the format is supposed to be ''

    I want my users to only have to worry about putting the first part of the email and when they exit that text field, for the and the apostrophe's to fill in automatically.

    I tried doing an input mask but it wasn't working. I think because there are different options for the front section. It might be firstname.lastname.ctr or firstname.lastname1 etc.

    Is this possible?

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Sure, but probably not with an input mask. In code:

    Me.TargetField = "'" & Me.SourceField & "'"

  3. #3
    Join Date
    May 2006
    Cool thanks - it worked!

Posting Permissions

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