If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format Command
I have a text box in a report using the Trim command where I need to change
the Formatting procedure for part of this as follows: =Trim("Born On"[Date of Birth],Format Bold, "In" [Place], Format Bold) I need the Date of Birth Field to be in bold and the Place to be in Bold. As I am relatively new, I would appreciate the correct syntax that I need to use and any help wil be greatly appreciated. |
#2
|
|||
|
|||
Format Command
The Format function cannot do what you're trying to do.
Assuming this is for a report, take a look at what Stephen Lebans has at http://www.lebans.com/mixbold-plain.htm If it's for a form, you're out of luck. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Roger Bell" wrote in message ... I have a text box in a report using the Trim command where I need to change the Formatting procedure for part of this as follows: =Trim("Born On"[Date of Birth],Format Bold, "In" [Place], Format Bold) I need the Date of Birth Field to be in bold and the Place to be in Bold. As I am relatively new, I would appreciate the correct syntax that I need to use and any help wil be greatly appreciated. |
#3
|
|||
|
|||
Format Command
If the date is being printed at a consistent width, which will depend on what
date format and font you are using, you should be able to do it as four separate controls; labels or unbound text boxes for "Born On" and "In", and bound controls for Date of Birth and Place. You can then set the FontWeight properties of the two bound controls to Bold. Ken Sheridan Stafford, England Roger Bell wrote: I have a text box in a report using the Trim command where I need to change the Formatting procedure for part of this as follows: =Trim("Born On"[Date of Birth],Format Bold, "In" [Place], Format Bold) I need the Date of Birth Field to be in bold and the Place to be in Bold. As I am relatively new, I would appreciate the correct syntax that I need to use and any help wil be greatly appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201001/1 |
Thread Tools | |
Display Modes | |
|
|