We help IT Professionals succeed at work.

insert bullets into an access report

thirdrockit
thirdrockit asked
on
1,265 Views
Last Modified: 2013-11-28
I have lists being generated first in a query, then being displayed onto the report using a sub report.  I am wanting these list to be in bullet format, much like you would do in word.  Is this possible?  I thought I saw a way to do this by putting the bullet in the SQL statement within an &''& statement but now I can't find it.
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
I guess you could prefix each item with

"> " & ListItem.

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
If you user the ChrW() function with the Unicode for the bullet character you want in the font you are using as a prefix, you s/b able to get a real bullet.

For example, bring up the Windows character map, select a font - like Verdana ... select the bullet and the code is U+25CF

mx
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Is it possible to do this in SQL?  This is my code.

SELECT "> " &   [Resume Knowledgebase].Detail & ', ' & Year([Resume Knowledgebase].AcqDate) AS Detaildate
FROM [Resume Knowledgebase]
WHERE ((([Resume Knowledgebase].RecType)=1));

The carrot shows up but is there something I can put in its place to show a bullet?
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
No ... SQL returns records, not formatted text.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
No.  What I suggest is for use on in text box displaying the records.

mx
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
thirdrockit,

"Bullets" are a Word Processing function.

They are not native to Access Reports or Crystal Reports

The simplest thing to do is to create your own collection of bullets.
Simply insert an image of your liking into the report, then position and resize it appropriately.

Or create your own "bullet" images with any Graphics Application.

JeffCoachman
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"The simplest thing to do is to create your own collection of bullets."

Jeff ... just an fyi.  You can use the ChrW() function to display any unicode character from any of the fonts.

mx
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
But not using SQL ...
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Right ... not using SQL,  But displaying the records on report in a text box - with the bullet preceding each record.

mx
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
OK,

Yes,

My post was just to say that you can just click: Insert-->Picture.

You can insert a limitless number of images and use them as Bullets.

Of course images take up a huge amount of space, but hey, that what DBPix is for!
;-)

But, yes you are correct, most of the "shapes" that are commonly used as Bullets, are avilable as special characters.
(The only one I have ever used is the Checkmark from the Wingdings font)
Another recent post also used these special characters to simulate the "Bars" of a Chart/Graph.
You learn something new everyday!
;-)

Thanks.

Jeff.

Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
To All:

FWIW,

I tried this:
SELECT Chrw(9679) AS Bullet, tblShippers.ShipperID, tblShippers.CompanyName, tblShippers.Phone FROM tblShippers;

And it worked fairly well.
The Bullet is it's own field.

JeffCoachman
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
outstanding ... so, it CAN be done in SQL.

mx
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
LOL!
;-)

You see, and I bet you thought I didn't pay attention to you!

;-)

But seriously, every new tip I learn, I immediatlely start testing it to see where it might be usefull.

Thanks for the great tip!
:D

Jeff
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
A point split s/b be in order here!

mx
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
MX,

We can leave that up to thirdrockit.
I'm just glad I learned a new tip!
:-O

I'm going through my character map docs now to see what other useful symbols there are.

Jeff
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
1000's of symbols !!!

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
3Rockit ... please reopen and split the points with Jeff.

mx

Author

Commented:
Thanks guys for all of your help.  The SQL tip will come in handy !!  

Author

Commented:
How do I reopen this question to split the points?
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
thirdrockit,

It's OK, don't sweat it.
We all learned something new thanks to MX's post
;-)

JeffCoachman
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"How do I reopen this question to split the points?"

Click the Request Button in the upper right of the page.

mx
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.