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
|
|||
|
|||
Formatting
I found this very useful for a report I was creating but I have the controls touching each other in design
mode in order to get the look I want. Why should they not be touching? what may happen? thanks, Jane ----- fredg wrote: ----- On Fri, 9 Apr 2004 00:41:03 -0700, Kate wrote: I am publishing a Member Directory report from Access with the following code: =[Address1] & Chr(13) & Chr(10) & IIf(IsNull([Address2]),"",[Address2] & Chr(13) & Chr(10)) & [City] & " " & [Postcode] & Chr(13) & Chr(10) & [Hometown] My question is....How can I get "Hometown" to print in italic. Because it is one textbox, I have no control over the individual fields. I am sure there is a simple formatting code to use, but I can't find it anywhere. Thank you for your help with this. Kind regards, Kate Kate, Using a regular Access text control, you can't if you use just one control. Since [Hometown] is on a line all by itself, however, simply end the expression with [Postcode]. Depending upon how you sized the control, set the control's Can Shrink and/or Can Grow properties to True. (I would size it just high enough for one line. It will then 'grow' as needed.) Then add the Hometown control under the above control. Set it's font to Italic. You may have to reposition the control up or down a bit to have it spaced one line down from the first control. Do NOT have it touching the above control. As the first control shrinks or grows, the Hometown will print, in italic, directly underneath it. Alternatively, you can purchase and install a third party Rich Text Format control, or see http://www.lebans.com for his free RTF control. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#2
|
|||
|
|||
Formatting
Jane wrote:
I found this very useful for a report I was creating but I have the controls touching each other in design mode in order to get the look I want. Why should they not be touching? what may happen? thanks, Jane It depends on what you mean by "touching". A CanGrow/CanShring text box can not actually overlap another control (by even the tinyiest amount) because the designer's intent of whether the other control should or should not be moved in what proportion with the new size of the text box. However, a CanGrow/CanShring text box can have its top/bottom at the same position as the bottom/top of another control so it is possible to have the borders of two controls appear to be in the same place, you just have to be very careful that they don't overlap or they won't grow or shrink. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Formatting
Actually, I believe that "Touching" is ok. "Overlapping" is not OK.
Access doesn't handle the Growing/Shrinking correctly when the controls overlap. Jane wrote: I found this very useful for a report I was creating but I have the controls touching each other in design mode in order to get the look I want. Why should they not be touching? what may happen? thanks, Jane ----- fredg wrote: ----- On Fri, 9 Apr 2004 00:41:03 -0700, Kate wrote: I am publishing a Member Directory report from Access with the following code: =[Address1] & Chr(13) & Chr(10) & IIf(IsNull([Address2]),"",[Address2] & Chr(13) & Chr(10)) & [City] & " " & [Postcode] & Chr(13) & Chr(10) & [Hometown] My question is....How can I get "Hometown" to print in italic. Because it is one textbox, I have no control over the individual fields. I am sure there is a simple formatting code to use, but I can't find it anywhere. Thank you for your help with this. Kind regards, Kate Kate, Using a regular Access text control, you can't if you use just one control. Since [Hometown] is on a line all by itself, however, simply end the expression with [Postcode]. Depending upon how you sized the control, set the control's Can Shrink and/or Can Grow properties to True. (I would size it just high enough for one line. It will then 'grow' as needed.) Then add the Hometown control under the above control. Set it's font to Italic. You may have to reposition the control up or down a bit to have it spaced one line down from the first control. Do NOT have it touching the above control. As the first control shrinks or grows, the Hometown will print, in italic, directly underneath it. Alternatively, you can purchase and install a third party Rich Text Format control, or see http://www.lebans.com for his free RTF control. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|