Results 1 to 5 of 5
  1. #1
    data808 is offline Noob
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    727

    Currency formatted Text Box Question

    How do you make the amount in a currency text box appear red if its negative? Right now it shows in parenthesis but I would like it to be red as well. Is this possible? It's also a calculated text box if that makes a difference.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Is this on a Report or Form?
    Perhaps try using Conditional Formatting.

  3. #3
    data808 is offline Noob
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    727
    this is on a form. how would i go about using conditional formatting?

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    See: http://stackoverflow.com/questions/1...ms-access-form

    There are also some of links on YouTube, if you would like to see some tutorials.

  5. #5
    data808 is offline Noob
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    727
    I figured it out. Thanks for much for the suggestions.

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

Similar Threads

  1. Replies: 5
    Last Post: 12-21-2013, 11:19 AM
  2. Creating formatted body text in Ms Outlook
    By capitala in forum Forms
    Replies: 2
    Last Post: 04-24-2013, 10:20 PM
  3. Trouble with date/time formatted as text...
    By fatboymedic in forum Import/Export Data
    Replies: 2
    Last Post: 09-25-2012, 10:34 AM
  4. Pasting formatted text into memo field
    By joekuhn in forum Access
    Replies: 0
    Last Post: 07-08-2011, 02:01 PM
  5. Currency/text display issues
    By Akazuba in forum Access
    Replies: 3
    Last Post: 04-20-2011, 07:51 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