Problem with trying to display bullets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UA Oz - 18 Oct 2005 07:30 GMT

I have a large number of Word documents which I need to transfer to Access
database. These documents have many bulleted lists. When I import them the
bulleted lists show in reports as a "dot then a square", and in web pages as
a "dot then a tab space" but text flowing onto the next line does not
recognize the indenting.

What I want is to be able to format as an HTML unordered list. I have also
tried HTML but the tags display in Access as text.

Is there aby way to show bullets correctly in Access???.

p.s. on checking the Access help it says to highlight the text in design
view and click the bullet button. Just 2 problems there - 1, the text is
generated from a database, and 2, I have tried everything and cannot seem to
make the button enabled.

Reply to this Message

Douglas J Steele - 18 Oct 2005 12:10 GMT

The only way to show bullets in Access would be to use RTF, which requires
that you use an RTF control.

Stephen Lebans has a free one at http://www.lebans.com/richtext.htm

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I have a large number of Word documents which I need to transfer to Access
> database. These documents have many bulleted lists. When I import them the
[quoted text clipped - 11 lines]
> generated from a database, and 2, I have tried everything and cannot seem to
> make the button enabled.

Reply to this Message

UA Oz - 18 Oct 2005 14:46 GMT

Thanks for the info and the direction I should look.

Unfortunately The Steohan Lebans control will not install for me. Does
anyone else have a link to a similar control?

Graham Cook

> The only way to show bullets in Access would be to use RTF, which requires
> that you use an RTF control.
[quoted text clipped - 18 lines]
> to
> > make the button enabled.

Reply to this Message

Douglas J Steele - 18 Oct 2005 15:42 GMT

Yes there are others, but they cost (and not all have the same functionality
as Stephen's). There's one available from FMS Inc, Total Access Memo
http://www.fmsinc.com/products/memo/index.html

What happens when you try to install Stephen's control?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Thanks for the info and the direction I should look.
>
[quoted text clipped - 25 lines]
> > to
> > > make the button enabled.

Reply to this Message

UA Oz - 19 Oct 2005 02:52 GMT

Hi Douglas,

I finally got the item to load. Have now tried it out but I cannot use it.
The reasons are; firstly I need to have a continuous form setup and this
can't be done with and ActiveX control, secondly I don't want to have to
format all the documents as RTF because I won't have control or access to the
vast majority of docs and also because the rtf markup displays when the page
is displayed in HTML.

I am resigned to letting Access malform the bullets in Access - it will be
"close enough" for display purposes, then use a regular expression to convert
to <li> in HTML. At least I can justify this to my client as a limitation of
Access.

Thanks for your help, it really assisted my problem solving of this vexing
issue.

Regards

Graham Cook

> Yes there are others, but they cost (and not all have the same functionality
> as Stephen's). There's one available from FMS Inc, Total Access Memo
[quoted text clipped - 39 lines]
> > > to
> > > > make the button enabled.

Reply to this Message