Format Integer Data Field to string

[terbs]

Sorry if this has been covered before, I wasnt sure on the correct search word criteria.

All I need is to format a textbox in a subform. The textbox is a integer data field E.g 1,2,3. If the text box is 1 then I want the text to display "In Stock", 2 "On Order. Etc..

Is this possible??

 

[WayneRyan]

terbs,

Use the Switch function:

Switch(YourInteger = 1, "In Stock", YourInteger = 2, "On Order" ...)

Wayne