A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formatting



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2004, 07:41 PM
Jane
external usenet poster
 
Posts: n/a
Default 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  
Old May 24th, 2004, 09:06 PM
Marshall Barton
external usenet poster
 
Posts: n/a
Default 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  
Old May 24th, 2004, 09:14 PM
John Spencer (MVP)
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.