Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Unanswered: Formatting - not the normal conditional

    I need to be able to set the displayed format (number of characters)
    differently for a field in each record on a continuous form. The formatted
    number of characters is based on the value in another field within the same

    I.e. the field "Nominal Value" is setup as a text field. "Resolution" is an
    integer. I need to be able to enter any number of characters both +/- and
    decimals yet DISPLAY only the number of characters past the decimal as
    indicated by the "Resolution Field". All of this needs to happen in a
    continuous form. Ive seen this done in Delphi but can it be done in Access?

  2. #2
    Join Date
    Nov 2003
    When you say past the decimal, do you left or right side?


  3. #3
    Join Date
    Feb 2004
    to the right i.e. if the Resolution is 3, I need the value 24.76354 to show as 24.763 yet still allow you to enter all the digits..

Posting Permissions

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