Format Combined Fields

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

Guest

Is there a way to format only specific parts of a concatenated field in a
report? I'd like to format the slashes between a part number and its
quantity by making it bold and/or larger than the other text.

I've combined multiple fields (15) in a query to make one field that's
included in a report at the bottom of each section. (Combined them because
the length of the data varies so much I couldn't fit them on the report
without overlapping each other) This way I can allow the one field to grow
and fit where necessary.
To try to make it easier to read I've separated them with a slash a space
and a star ( *). It is still difficult to read.

The combined field consists of [ComponetPN1]&" / "&[Qty1]&" *
"&[ComponentPN2]&" / "&[Qty2]&" * "&....etc upto 15 component parts.

Thx so much
 
Is there a way to format only specific parts of a concatenated field in a
report? I'd like to format the slashes between a part number and its
quantity by making it bold and/or larger than the other text.

I've combined multiple fields (15) in a query to make one field that's
included in a report at the bottom of each section. (Combined them because
the length of the data varies so much I couldn't fit them on the report
without overlapping each other) This way I can allow the one field to grow
and fit where necessary.
To try to make it easier to read I've separated them with a slash a space
and a star ( *). It is still difficult to read.

The combined field consists of [ComponetPN1]&" / "&[Qty1]&" *
"&[ComponentPN2]&" / "&[Qty2]&" * "&....etc upto 15 component parts.

Thx so much
Click to expand...

No, you cannot have bold and un-bold formatting within an Access
control.

However, you can:

1) Install a RichTextFormat control (see htpp://www.lebans.com for a
free one).

Or

2) It would be even easier to read if you simply had each part number
and it's Qty on separate lines:
=[ComponetPN1] &" "&[Qty1] & chr(13) & chr(10) & [ComponentPN2] &"
"& [Qty2] & chr(13) & chr(10) & etc.

PN 129846 5
PN 099817 2
etc.

Set the control's CanGrow as well as the report section's Can Grow
property to Yes.
Note: The Page Header and Footer sections do not have a Can Grow
property.
 
Thank you will look at rich text.
Putting them on separate lines will not work for us. The report is already
about 20 pages and 15 additional lines to each finish part number would be
too much. That's the main reason we combined the fields in the first place,
to make it one field / one line (that can grow) That way it runs across the
page beneath the rest of the data instead of as a list below it.

Thx again. Will try looking at rich text.

fredg said:
Is there a way to format only specific parts of a concatenated field in a
report? I'd like to format the slashes between a part number and its
quantity by making it bold and/or larger than the other text.

I've combined multiple fields (15) in a query to make one field that's
included in a report at the bottom of each section. (Combined them because
the length of the data varies so much I couldn't fit them on the report
without overlapping each other) This way I can allow the one field to grow
and fit where necessary.
To try to make it easier to read I've separated them with a slash a space
and a star ( *). It is still difficult to read.

The combined field consists of [ComponetPN1]&" / "&[Qty1]&" *
"&[ComponentPN2]&" / "&[Qty2]&" * "&....etc upto 15 component parts.

Thx so much
Click to expand...

No, you cannot have bold and un-bold formatting within an Access
control.

However, you can:

1) Install a RichTextFormat control (see htpp://www.lebans.com for a
free one).

Or

2) It would be even easier to read if you simply had each part number
and it's Qty on separate lines:
=[ComponetPN1] &" "&[Qty1] & chr(13) & chr(10) & [ComponentPN2] &"
"& [Qty2] & chr(13) & chr(10) & etc.

PN 129846 5
PN 099817 2
etc.

Set the control's CanGrow as well as the report section's Can Grow
property to Yes.
Note: The Page Header and Footer sections do not have a Can Grow
property.
Click to expand...
 
Back
Top