Bulleted Text on a Report

[SherryW]

This is probably a very basic question but, I cannot seem to come up with a
way to incorporate bullets into a report section

The report contents are coming from a single query against a table. Within
the table, the field is a memo field and I cannot put bullets within this
table. I tried doing it in word and then copying the text into the table
which works sort of with the exception of the bullets being extremely small.
I was then hoping that within the report section that I would be able to
incorporate proper bullets but I can't seem to figure out how to do it.

Any help would be greatly appreciated as this report is looking good with
the exceptional of these blasted bullets and without them, the report is not
usable.

 

[Allen Browne]

Unless you are working with Access 2007 (the one that's about to be
released), you cannot store rich text (such as bulleted paragraphs) and have
display it in the standard Access text box.

You can do it if you install a 3rd party Rich Text Control such as this one:
http://www.lebans.com/richtext.htm

You can do it if you upgrade to Access 2007.

The only other alternative is to fudge it by inserting a bullet character,
and typing spaces to try to make them line up. You can copy the bullet from
Word, or from the Character Map applet.

 

[SherryW]

Thanks Allen, I was afraid of that.

I'll figure out a way to fudge it. Unfortunately our company (despite my
whining) is not open to the idea of upgrading to anything past what we
already have ... which is 97.

 

[Jeff Boyce]

I'm not clear whether you are trying to embed bullets within a memo field,
or if you are using the memo field as a "detail record" in your report. Do
you wish to show bullets within a single memo field (see Allen's response),
or are you trying to list multiple records, each with a bullet?

If the latter, open your report in design view, make sure your field/control
is in the Details section, then add a control that contains the character
(bullet) that you wish to see, immediately to the left of the (memo) field
control. This way, every new detail printed will have a character (bullet)
on its left.

Or have I misunderstood your description?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[SherryW]

What I had was a memo table field called assumptions. Within this field was
5 bulleted items. In order to get the bullets in the table, I had typed it
out in word and then copied it into the assumptions field. When creating
the report, I created a text box called Assumptions and tried to pull in the
assumptions data from the table/query. This didn't work well for me for the
following reasons, bullets took on same font size as the rest of the text
and, it didn't flow well when the text wrapped.

After finding out there wasn't an easy way to do it, I created more fields
in the table and query. One Bullet field and 5 assumptions fields. I was
then able to create a text box in the report for the bullet and place the
assumption beside it (x5). This worked beautifully I was able to control the
size of the bullet and the text wrapping.

Thanks for the assistance gentlemen, you were a great help!
SherryW