Listbox currency format

[princess12]

hello everyone,

so basically the field is set as currency

the format of textbox is set as currency

listbox source is from the table, also tried in query

am trying to get the value from listbox to textbox. it works in my other forms,


then how come in the current form instead of reading currency value as £10.00 it shows as -0.073425925925926 in textbox

Me.txtbox1 = Me.lstEInfo.Column(5)

any idea, thanks alot

[pbaldy]

First thought is to verify you have the correct column. Is the value you want in the 6th column of the listbox row source?

[princess12]

thank you, usually the columns always start from 0, 1, 2

but after filter it seems like it start from one, thanks a lot

also let say the textbox says 10 when it actually £10.00 how do i make it show as £10.00

thanks alot

[princess12]

no worries, figured it out , thanks

[pbaldy]

No problem. It should be zero based; I wonder if your filtering is changing the columns.

[princess12]

the filter changes the column a little bit meaning before filter ID field is shown after filter it not shown despite putting ID in the filter listbox row source. it doesn't really make a difference, as long as it doing what it suppose to. thank you very much for your help i really appreciate it

[princess12]

in regarding to this topic, if the column of listbox is the right one and still the textbox shows as integer what could be the reason and is there anything i can do? thanks.

also this occurs in the different form but the principle is the same.

[pbaldy]

Have you tried setting the format property of the textbox? If so, perhaps it's being seen as text, so try

Me.txtbox1 = CCur(Me.lstEInfo.Column(5))

[princess12]

omg! yes it works, thank you so much, Yayyy!!!, thanks a lot

[pbaldy]

Happy to help!