Combo box displaying year value aligned to right

[Pollock]

Ok, this one is a puzzle. I create a cursor of distinct years from a table. I make the combo box rowsource the cursor field and the rowsourcetype is alias. When the form comes up the year is aligned to the right so only the first two numbers show. I need it aligned to left so full year shows.

 

[white605]

Does your combo box control have an alignment property?

This old world keeps spinning round - It's a wonder tall trees ain't layin' down

 

[Pollock]

The alignment is set to left, but problem seems to be that foxpro is converting the numeric to string when it puts it in the list and the string is being padded with spaces. These spaces are forcing the number to be partially hidden

 

[Imaginecorp]

strange I dont see that...

The Year(date()) is alligned to the left... is century set to on and what is the combo width (not column width) set as?

 

[jdhilljr]

Use alltrim
ALLTRIM(STR(YEAR(DATE())))

If you can't stand behind your troops, stand in front of them.
Semper Fidelis

Jim

 

[TamarGranor]

Combos and lists can only contain character data. When you give them something else, they convert it internally.

 

[Stella740pl]

...foxpro is converting the numeric to string when it puts it in the list and the string is being padded with spaces.

So convert it yourself, and be sure to specify number of symbols you need, so there won't be any padding:
STR(YEAR(DATE()),4)