Center listbox columns' content individually

[richardw]

Hi All,


I am trying to center the content of my listbox.
I did the tour of all forums, but found nothing helpful..

I want to center the columns individually (because there is some of them that i wouldn't them to be centered).
The problem is that Microsoft didn't make it native to center a listbox

Is there a code or a function to create to do so?


I know it's a bit hard as a request
Thank you in advance

 

[arnelgp]

if it is based on table (your listbox), you can make it appear center by editing your table.
on property window->Text Align->Center.

 

[sneuberg]

There are some sites, https://sites.google.com/site/msaccesscode/controls-2/textalignmentforalistbox for example that say you can change the list box to a combo box, change the text alignment, and then change it back to a list box. It seems to depend on the version you have. I can't get it to work in Access 2013

 

[richardw]

Thanks guys, Arnelgp's solution worked perfectly