Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Accounting Style Format for Money Field (Access XP >)

    HI,
    Here is another quick formatting Q!

    How can I set up a format to show the Currency Symbol lined up on the left... (Accounting Format in Excel)??

    I copied the format from excel and pasted it into the format property of a calculated field in a query and the format does not display well...even after attempts to tweak it!

    Any ideas to define the format!
    Tx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Accounting Style Format for Money Field (Access XP >)

    Use a format like this:
    <code>$* 0.00</code>
    or
    <code>$* #,##0.00</code>
    The asterisk followed by a space tells Access to insert as many spaces as needed to left-align the symbol before it.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Accounting Style Format for Money Field (Access XP >)

    <P ID="edit" class=small>(Edited by Rudi on 01-Nov-05 16:13. Sorry....not that symbo....That is the "!"..."/" is for display or print characters in input masks!)</P>Many tx again...
    I notice Acess puts a "/" (or is it the "") in the front! (I recall this symbol as the one to in input masks to fill from right to left!)

    Anyways...tx again for the help Hans!
    See ya
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Accounting Style Format for Money Field (Access XP >)

    The "" is used to indicate that the following character is a literal character, not a formatting code.

    If you click in the Format property of a field or control and press F1, you'll get all the necessary information.

Posting Permissions

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