Have you checked the validation rules on this field? Maybe the problem lies there.
Regards Pete --- In [email protected], "bunkyfoly" <[EMAIL PROTECTED]> wrote: > Access 2002/2003. I have inherited an old Access 2000 database where > one of the fields in the table had a Number data type containing > TEXT. I noticed the wrong data type and I changed it to text. All > appeared OK until I attached a combo box to this field. Whenclicking > in or opening the combo box in any row in this table with the old > text, I get an error message: "The value you entered isn't valid for > this field. For example, you may have entered text in a numeric > field or a number that is larger than the FieldSize setting permits." > > This field has about 3,000 records in it, and it appears to be > corrupted and a permanent numeric field, I have tried everything to > fix it: Compact and Repair; Import, append, and update this field into > another table/field and I cannot get rid of the error message. How > doI get this Number field finally and completely converted into aTEXT > field? > > Anyone got any ideas? Thank-You! ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hg13fee/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124793214/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
