Formatting numbers in combo-boxes - basic.visual

Found the solution with the aid of a friend.
If anyone else stumbles at this point:
With the use of FormatNumber(...), you can format the item before
adding it to the combobox-list

cmb_1.AddItem (FormatNumber(rsI!SB_Euro, 0, vbUseDefault,
vbUseDefault, vbUseDefault))


A.S.

On 16 Mrz., 15:11, "Alex Sauer" <dead.man.walk...@gmx.de> wrote:
> Hello NG!
>
> Being a newbee to VB6.0, I'm faced withe the following problem:
> I'm using VB6.0 on WinXP Pro to re-engineer a DB-frontend.
> There a several frames containing combos based on fixed lists of
> values.
> This, I like to change to combos, whose lists are derived from
> database-tables.
>
> Having succeeded in doing so, I now have to cope the fact, that the
> format of the values is lost
> Within the table (Access '79) the format is "#.##0" (european number-
> format, no digits after comma, dot separates the thousands)
> Exactly the same format would be appreciated in the VB-form
>
> But since ' combobox1.DataFormat.Format = "#.##0" ' or '
> combobox1.DataFormat.Format = "#,##0" ' doesn't work, I'm totally at a
> loss.
>
> Any help will be appreciated!
> Alex