Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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.
 
Kate said:
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.
Click to expand...

It's not simple at all. To get different formats in
different parts of a control, you would have to use an RTF
type of control, which is probably way more trouble than
it's worth in your case.

I would try to find a way to use a separate text box to
display the hometown field. See if you can keep the two
text boxes close together by using CanShrink on the first
text box.
 
I found this very useful for a report I was creating but I have the controls touching each other in desig
mode in order to get the look I want. Why should they not be touching? what may happen
thanks, Jan

----- fredg wrote: ----

I am publishing a Member Directory report from Access with th
following code: =[Address1] & Chr(13) & Chr(10) &> IIf(IsNull([Address2]),"",[Address2] & Chr(13) & Chr(10)) & [City
& " " & [Postcode] & Chr(13) & Chr(10) & [Hometown] My questio
is....How can I get "Hometown" to print in italic. Because it i
one textbox, I have no control over the individual fields. I a
sure there is a simple formatting code to use, but I can't find i
anywhere. Thank you for your help with this. Kind regards, Kat
Click to expand...

Kate,
Using a regular Access text control, you can't if you use just on
control.
Since [Hometown] is on a line all by itself, however, simply end th
expression with [Postcode]
Depending upon how you sized the control, set the control's Can Shrin
and/or Can Grow properties to True. (I would size it just high enoug
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 i
spaced one line down from the first control. Do NOT have it touchin
the above control
As the first control shrinks or grows, the Hometown will print, i
italic, directly underneath it

Alternatively, you can purchase and install a third party Rich Tex
Format control, or see
http://www.lebans.com
for his free RTF control
 
Jane said:
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
Click to expand...


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.
 
Actually, I believe that "Touching" is ok. "Overlapping" is not OK.

Access doesn't handle the Growing/Shrinking correctly when the controls overlap.
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: -----

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
Click to expand...

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.
Click to expand...
 
Back
Top