bullet list in report

[Tony]

I would like to create bullet list in my report (with intended text). Can it
be done in Access ?
I am thinking of using two different subreports, one with bullet one without
and use one of them depending on the value of the check box. Is it possible
to use condition to select subreport ?

Thanks for advise

Tony

 

[Jeff Boyce]

Tony

An Access report is a "print-able" output. Are you saying you want to see a
list with a bullet before each item?

I've created an Access report with a "list" in the Details section, and
preceded the row with a textbox holding a "bullet". That way, every time
Access prints another row in the Details section, it is also printing that
textbox holding the bullet.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Allen Browne]

Access 2007 supports rich text, so you can have bulleted lists with
indentation etc in the new version.

Previous versions don't support this in the standard Access text box. There
are 3rd party ones such as:
http://www.lebans.com/richtext.htm

It is possible to simulate a bulleted list in plain text, using an asterisk
or lower case letter o as a bullet, and indenting the text with spaces. Some
Unicode fonts have a solid circle, so you may be able to use the CharMap
applet to locate the character, and paste into your plain text in Access
2000 and later.

If you do wish to use rich text in Access 2007, and have a 2nd subreport
that strips it back to plain text, use the PlainText() function.

 

[Tony]

Hi Jeff,

Thank you for your response. But what to do if for some items I want bullet
and intended text while for others I do not want bullet ? I want it to look
like:

• Sample text sample text sample text sample text sample text
sample text sample text sample text sample text sample text
sample text
Second paragraph second paragraph secon paragraph second paragraph
second paragraph
• Third item third item third item

Any suggestions on how to do this ???

Regards,

Tony

 

[Tony]

Hi Allen,

Thank you for your response. Please read my response to Jeff to find on what
I realy want. Is this third party add in going to do what I want ?

Regards,

Tony

 

[Jeff Boyce]

I'm afraid I see neither rhyme nor reason why one row would be bulleted and
another not.

How are YOU deciding which ones get bullets?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fredg]

I would like to create bullet list in my report (with intended text). Can it
be done in Access ?
I am thinking of using two different subreports, one with bullet one without
and use one of them depending on the value of the check box. Is it possible
to use condition to select subreport ?

Thanks for advise

Tony

You can place a bullet in your report manually at any time when
entering the text in the field.
Alt + 0149 (using the number pad) will enter the bullet.
¡E This is the rest of the paragraph.

Or... you can place it in the field when printing, using an unbound
text control.

=IIf([CheckBox] = True, Chr(149) & " " & [TextField],[TextField])

The size of the bullet is dependent upon the font size used in the
control.

 

[Tony]

I know how to add bullet, it is not an issue. How I can have the text
indented ? It can be done with two text boxes too. But I have some items I
want to have bullet for and some to be without bullet. See my reply to Jeff.

Any more suggestions ?

Regards,

Tony

I would like to create bullet list in my report (with intended text). Can it
be done in Access ?
I am thinking of using two different subreports, one with bullet one without
and use one of them depending on the value of the check box. Is it possible
to use condition to select subreport ?

Thanks for advise

Tony

You can place a bullet in your report manually at any time when
entering the text in the field.
Alt + 0149 (using the number pad) will enter the bullet.
‧ This is the rest of the paragraph.

Or... you can place it in the field when printing, using an unbound
text control.

=IIf([CheckBox] = True, Chr(149) & " " & [TextField],[TextField])

The size of the bullet is dependent upon the font size used in the
control.