Results 1 to 4 of 4
  1. #1
    Subs is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2013
    Posts
    5

    Rich text - text color and size

    Hopefully this is an easy noob question. I text boxes in reports where I would like certain portions to be blue text and others to be in very small font. Is there a way to do this with Access 2007.



    ie.
    <B>= bold
    <?> = blue text
    <?> = small text

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Use a textbox bound to Memo type field set for RTF. http://office.microsoft.com/en-us/ac...010031118.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Subs is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2013
    Posts
    5
    Thank you, but I don't think that will work for my particular situation.

    I am importing .csv files from other databases which means the data from my tables is dumped and recreated each day. The text I need colored actually comes from a date/time. I need to display total time underlined, eastern in plain text, and zulu time in bold blue text. below is an example of the desired result and the control of the textbox as it is now.

    583 Hrs
    Thu 07-Nov 0400E
    Sun 01-Dec 1100E
    Thu 07-Nov 0900Z
    Sun 01-Dec 1600Z



    ="<U>" & Round((([ScheduledEndDate]-[ScheduledStartDate])*24),2) & " Hrs </U>" & "<BR>
    " & Format(([ScheduledStartDate]-(5/24)),"ddd dd-mmm hhnn\E") & "
    <BR>" & Format(([ScheduledEndDate]-(5/24)),"ddd dd-mmm hhnn\E") & "
    <BR><B>" & Format([ScheduledStartDate],"ddd dd-mmm hhnn\Z") & "
    <BR>" & Format([ScheduledEndDate],"ddd dd-mmm hhnn\Z") & "</B>"

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    If you want the entire contents of textbox to be colored based on some criteria, then use Conditional Formatting, not RTF.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Margins for OLE Unbound Rich text box
    By yoili in forum Reports
    Replies: 0
    Last Post: 02-17-2013, 11:46 AM
  2. Replies: 1
    Last Post: 05-24-2012, 04:59 AM
  3. rich text memo field
    By jedder in forum Reports
    Replies: 1
    Last Post: 05-11-2012, 02:48 PM
  4. Set format of rich text field
    By silverspr in forum Programming
    Replies: 0
    Last Post: 03-28-2011, 09:07 AM
  5. Macro to set rich text attributes?
    By EER in forum Programming
    Replies: 0
    Last Post: 03-04-2009, 09:25 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