Can I get my report output in bullet format?

[Guest]

I need my text output in bullet format but don't see any way to do this. Is
it possible?

 

[Duane Hookom]

If each bulleted text is in a different control you can add a text box to
the left of the text and set properties;

Control Source: =Chr(159)
Font: Wingdings

 

[Guest]

Hello, Mark - I am needing the same information. Have you found anything
useful?

 

[Duane Hookom]

This was the advice given to Mark:

If each bulleted text is in a different control you can add a text box to
the left of the text and set properties;

Control Source: =Chr(159)
Font: Wingdings

 

[Guest]

Any way to do this with all text in one control, not separate controls?

 

[Duane Hookom]

You could do this with a rich text control.

You haven't ever really described your requirements.

 

[Guest]

Our HR department has been been generating reports containing job
descriptions from Word, and we have decided it would be much more efficient
to generate these reports in Access. The job descriptions have been written
in Word in a bulleted format, and I am trying to cut and paste that
information into an Access database field. But, I have been unable to find a
solution to formatting this information without creating a field for each job
description item. I just want that field to populate my report and print off
the information in a bulleted format to look exactly how the report generated
from Word looks. Can you help?

 

[Duane Hookom]

Yes, I can help. Change your table structure so that each "job description
item" becomes a record in a related table. This would normalize your tables
and be the best thing since sliced bread for your HR department and you.

tblJobs
==================
jobJobID autonumber primary key
jobTitle
jobShortDescription
jobReportsTo
jobStatus


tblRequirements
===================
reqReqID autonumber primary key
reqTitle values like "Masters in Education" or "CDL" or ....
reqStatus

tblDuties
==================
dutDutID autonumber primary key
dutTitle values like "Perform other duties as needed"

tblJobRequirements
=========================
jorJoRID autonumber primary key
jorJobID link to tblJobs.jobJobID
jorReqID link to tblRequirements.reqReqID
jorStatus

tblJobDuties
======================
jodJoDID autonumber primary key
jodJobID link to tblJobs.jobJobID
jodDutID link to tblDuties.dutDutID
jodStatus

You can now use sub forms and subreports to mix and match job with
requirements and duties.