Is there a way to center (horizontally) items in a list box?

I want each individual item in the list box to be centered horizontally. I don't see any properties that allow me to do this, nor any VBA code I can apply. When I tried adding leading blanks and using a fixed font such as Courier New, Access would trim off the leading blanks and left justify the text.
I am using MS Access 2007.

Thanks

EggHeadCafe - Software Developer Portal of Choice
HTML Hyperlink Obfuscation with Client Script
http://www.eggheadcafe.com/tutorials...bfuscatio.aspx

Open in design view, click on Property Sheet and format property Text Align
sekect Center.
--
Build a little, test a little.


"Wol Bruin" wrote:

I want each individual item in the list box to be centered horizontally. I don't see any properties that allow me to do this, nor any VBA code I can apply. When I tried adding leading blanks and using a fixed font such as Courier New, Access would trim off the leading blanks and left justify the text.
I am using MS Access 2007.

Thanks

EggHeadCafe - Software Developer Portal of Choice
HTML Hyperlink Obfuscation with Client Script
http://www.eggheadcafe.com/tutorials...bfuscatio.aspx
.

Karl,

You can't center text in a list box... but I found something you posted a
little back that works like a charm...

SELECT Space(15-len([FieldName])/2) &[FieldName] FROM [TableOrQueryName];

Note, you may have to play with the * -15 * depending on the width of your
list box.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"KARL DEWEY" wrote in message
...
Open in design view, click on Property Sheet and format property Text
Align
sekect Center.
--
Build a little, test a little.


"Wol Bruin" wrote:

I want each individual item in the list box to be centered horizontally.
I don't see any properties that allow me to do this, nor any VBA code I
can apply. When I tried adding leading blanks and using a fixed font
such as Courier New, Access would trim off the leading blanks and left
justify the text.
I am using MS Access 2007.

Thanks

EggHeadCafe - Software Developer Portal of Choice
HTML Hyperlink Obfuscation with Client Script
http://www.eggheadcafe.com/tutorials...bfuscatio.aspx
.