Results 1 to 6 of 6
  1. #1
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84

    formatting text in report to currency

    How do I display/format currency in a text box in a report?



    The report shows:
    (3) Please forward a check to Rose Smith in the amount of 14721, but want to show $14,721.00.

    so far I have:
    ="(3) Please forward a check to " & [claimantfirst] & " " & [claimantlast]&" in the amount of [seed money]

    so i want to format [seed money].

    examples are appreciated, but i also want to learn how to format fields witinin a text box.

    Thanks,

    John

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Try
    format(14271,"$###,###.00")

    perhaps
    format([seed money],"$###,###.00")

  3. #3
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84
    Thanks for your help. I used your second suggestion but doesn't seem to work. I'm sure it's my mistake. Here's the whole text box:

    ="After the court approves the settlementl, please make a check to " & [claimantfirst] & " " & [claimantlast] & " and forward to Attorney " & [tContacts.CfirstName] & " " & [tContacts.CLastName] & " in the amount of format([seed money],"$###,###.00")

    Thinking I need the & surrounding the field like "&[seed money]&" or quotes or ()...something like that.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please show us where [seed money] is defined in your application if this doesn't work.

    ="After the court approves the settlementl, please make a check to " & [claimantfirst] & " " & [claimantlast] & " and forward to Attorney " & [tContacts.CfirstName] & " " & [tContacts.CLastName] & " in the amount of " & format([seed money],"$###,###.00")

    ??Is this a spelling issue settlementl

  5. #5
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84
    Perfect! Thanks. yes, settlement was misspelled. thanks for your help!

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Decimals, formatting maybe currency.
    By Perfac in forum Programming
    Replies: 3
    Last Post: 01-27-2018, 09:24 AM
  2. formatting currency
    By osas in forum Programming
    Replies: 1
    Last Post: 10-27-2017, 08:32 AM
  3. Currency formatting without the USD symbol
    By Symlink in forum Access
    Replies: 1
    Last Post: 07-13-2013, 07:40 PM
  4. formatting a field to be currency in VBA
    By Lupson2011 in forum Forms
    Replies: 8
    Last Post: 06-25-2012, 08:02 AM
  5. HELP! formatting currency
    By jgelpi16 in forum Reports
    Replies: 1
    Last Post: 07-06-2010, 09:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums