display/print 3 charactors out of 10 in bold

display/print 3 charactors out of 10 in bold

Post by Denni » Mon, 03 Nov 2003 05:21:16

I have a report that displays/prints budget line numbers
in a report. I wish to print the 5th, 6th, & 7th number in
bold on the report as those three numbers represent
information that helps the reader relate the 3 numbers to
the budget line description. I need to know where and
what to do to make this happen and I do not want to break
the budget line number apart in 3 separate fields. The
field in the report is from a select distinct row query
and the field originates in a table named tblBudgetSubtype
and the field name is BudgetSubtypeNumber. Thanks,


display/print 3 charactors out of 10 in bold

Post by John Vinso » Mon, 03 Nov 2003 06:04:26

On Sat, 1 Nov 2003 12:21:16 -0800, "Dennis"

Sorry - if that's the case you are out of luck. Access simply does not
support mixed fonts within a single textbox.

You can purchase a Rich Text Format control and (with some difficulty)
construct a memo field containing RTF text, or you can use three
textboxes; I'd be inclined to do the latter, since it sounds like
these are logically three different fields which should be stored
separately and combined for display purposes.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday


display/print 3 charactors out of 10 in bold

Post by DanK » Mon, 03 Nov 2003 18:04:03

I'm not sure what you're trying to do but if it what I
think it is, YES YOU CAN. Here's how:

Create a query with the column names as follows:

1: Left([FieldName],4).
2: Mid([FieldName],5,3)
3: Mid([FieldName],8,20)

Place three controls named 1,2, and 3 (with their
ControlSources set respectively) butt-up next to each
other on your report. Format the center one bolded. Play
with the sizing so that the three controls together "LOOK
LIKE" one.

email me if you need to.