DAPPLE
04-15-2002, 04:05 AM
Somehow my field thinks it can only receive numbers. I compared the properties tabs to another field that will receive text, and they're both the same. What am I missing. This field didn't have any data from the orig table to determine whether to format text or numbers. Would greatly appreciate some input
Jack Cowley
04-15-2002, 06:22 AM
Did you check the Data Type for the field in the table? Is it set to Text?
DAPPLE
04-15-2002, 07:53 AM
How do I find the 'data type'. I double clicked on the field in design view and searched the properties tab. Didn't see anything with that heading.
Jack Cowley
04-15-2002, 09:03 AM
Open the table, in design view, that the form is based on. In the column immediately to the right of the field name is a column called Data Type. Here you will see Text, Yes/No, Number, etc. Be sure this says Text and not Number for the field in question.
DAPPLE
04-15-2002, 09:06 AM
I found it! Thanks Jack... That sure helps.