This is probably a very basic question with an obvious solution. I have a form that collects both character and numeric input. The data is saved to a table without trouble. The user sometimes needs to correct data already entered into the table. Using the same form I take the data from the tables and place it into the controls where it can be edited and then used to update the table. One control is a textbox that collects numeric information. It's InputMask = ####### and MaxLength = 7. Numeric data is entered and saved to the table in a numeric field.
(the problem) To edit, the data is taken from the table, the numeric field, and then put into the textbox with
THISFORM.txtSupplyCost.VALUE = CurrentData.SupplyCost. At that point the value of the textbox is Character not Numeric. Why isn't it numeric and how do I make it numeric?
Thanks!
Jim Philippi
quando omni flunkus moritati