insert bullets into an access report

I guess you could prefix each item with

"> " & ListItem.

mx

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

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?

No ... SQL returns records, not formatted text.

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

mx

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

"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

But not using SQL ...

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

mx

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.

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

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

mx

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

A point split s/b be in order here!

mx

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

1000's of symbols !!!

mx

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

mx

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

How do I reopen this question to split the points?

thirdrockit,

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

JeffCoachman

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

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

mx