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
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
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.
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>"
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.