List Box alignment

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

A list box displays the results of all the columns from an
underlying query correctly with the exception of a column:

Extended: CCur(Format([Order Details].[UnitPrice]*
[Quantity]*(1-[discount]),"$##,###.00"))

The amounts are left aligned.

Any way to have them appear right aligned in the list?
 
I think you mean combo box, not a list box.

In a combo box's dropdown list, the columns that are not the bound column
often are treated as text when displayed (and text is always left-aligned by
ACCESS as the default), regardless of what format you've set for them. I
don't know of a way to change the display that you're seeing.
 
Ken:

Actually it is a list box created using the List Box
wizard on the the tools bar.

I followed the example in the Northwinds sample database.
In any event it appears I will have to live with the left
alignment in the Extended column. Thanks anyway.

Rick
-----Original Message-----
I think you mean combo box, not a list box.

In a combo box's dropdown list, the columns that are not the bound column
often are treated as text when displayed (and text is always left-aligned by
ACCESS as the default), regardless of what format you've set for them. I
don't know of a way to change the display that you're seeing.

--
Ken Snell
<MS ACCESS MVP>

A list box displays the results of all the columns from an
underlying query correctly with the exception of a column:

Extended: CCur(Format([Order Details].[UnitPrice]*
[Quantity]*(1-[discount]),"$##,###.00"))

The amounts are left aligned.

Any way to have them appear right aligned in the list?
Click to expand...


.
Click to expand...
 
My apologies....I misread your post...where you had list box, my brain
recorded text box.

OK - list box and combo box display the columns similarly. My comments for
the combo box apply for the list box too.


--
Ken Snell
<MS ACCESS MVP>

Ken:

Actually it is a list box created using the List Box
wizard on the the tools bar.

I followed the example in the Northwinds sample database.
In any event it appears I will have to live with the left
alignment in the Extended column. Thanks anyway.

Rick
-----Original Message-----
I think you mean combo box, not a list box.

In a combo box's dropdown list, the columns that are not the bound column
often are treated as text when displayed (and text is always left-aligned by
ACCESS as the default), regardless of what format you've set for them. I
don't know of a way to change the display that you're seeing.

--
Ken Snell
<MS ACCESS MVP>

A list box displays the results of all the columns from an
underlying query correctly with the exception of a column:

Extended: CCur(Format([Order Details].[UnitPrice]*
[Quantity]*(1-[discount]),"$##,###.00"))

The amounts are left aligned.

Any way to have them appear right aligned in the list?
Click to expand...


.
Click to expand...
Click to expand...
 
I am sure that I have seen somewhere code to do the alignment but I do not
remember where!
I'll try to find it!
In the mean while try a search in google news for "list box alignment"
Good hunting!
Margaritis Paktitis
 
Check out
www.Lebans.Com

Specifically

http://www.lebans.com/justicombo.htm



Margaritis said:
I am sure that I have seen somewhere code to do the alignment but I do not
remember where!
I'll try to find it!
In the mean while try a search in google news for "list box alignment"
Good hunting!
Margaritis Paktitis
? "Rick said:
A list box displays the results of all the columns from an
underlying query correctly with the exception of a column:

Extended: CCur(Format([Order Details].[UnitPrice]*
[Quantity]*(1-[discount]),"$##,###.00"))

The amounts are left aligned.

Any way to have them appear right aligned in the list?
Click to expand...
Click to expand...
 
Back
Top