Changing format of a textbox filled with combobox column value

[Summit_IT]

I have a form with three textboxes that are based on one combobox. Two of the three are Yes/No and the last one is Currency. The Yes/No shows as "0" or "1". I want "Yes" or "No". The last one shows a General number. I need it to show it as Currency.

"=[cboMPL_ID].[Column](5)"

[Micron]

You should be able to format the text boxes on the property sheet. Check 'format' line on format tab of the sheet - Yes/No is an option that should be there for at least the first two you mention. However, I'm thinking there may be something going on behind the scenes (like in the table fields) because the norm for true/false (or yes/no) is that number values are -1 and 0 respectively. You say you're getting 1, not -1.

[ranman256]

set the txtbox value yes/no:

vRet = cboMPL_ID.Column(5)
Text1 = Switch(vRet = 1, "Yes", vRet = 0, "No")


format property of the 3rd text box as currency

[Summit_IT]

set the txtbox value yes/no:

vRet = cboMPL_ID.Column(5)
Text1 = Switch(vRet = 1, "Yes", vRet = 0, "No")
This worked!
Thanks!
format property of the 3rd text box as currency

I had set the format to currency. What about this?

[CJ_London]

data in a combo or listbox is all 'typed' as text.

try
=cCurr([cboMPL_ID].[Column](5))

[Summit_IT]

Used something like this "ListPrice: Format([MasterListPrice],'$#,###.##')" in combobox query and this fixed it.

Thanks to all!

[CJ_London]

the format function generates a text value, which is OK providing you don't want to use it in a calculation