Results 1 to 4 of 4

Thread: Format field

  1. #1
    Join Date
    Mar 2008
    Posts
    8

    Question Unanswered: Format field

    Hello,

    Need some help with the following:

    I have a form in which one field needs to handle two different display formats, data is already stored as String and form is used to display data only.

    (1) 99.99.9999.999999

    (2) 9999-999999

    Any ideas??

    Thanks in advance
    Carlos

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    603
    Provided Answers: 31
    on what condition does the format change?
    you can set FORMAT (txtbox,xxxxx) in the ON CURRENT event. But when/why?

  3. #3
    Join Date
    Mar 2008
    Posts
    8
    Ranman, tried On-Current event but that only works when field gets focus.

    attached pic is a an example of what Im trying to accomplish, two different numbers with different size, I would like set them with their own correct format.
    Attached Thumbnails Attached Thumbnails Example.jpg  

  4. #4
    Join Date
    Mar 2008
    Posts
    8
    Never mind, found solution.

    Worked by creating a SELECT query within Form RecordSource, used an IIF to check data length and base on it, formatted field. Work great!

Posting Permissions

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