1 of 1 people found this helpful
go to the first layout and go to layout mode. click once on the "good field" and open the inspector. choose the data tab and scroll down to the "Data Formatting". check the settings for this field. then go to the other layout and the "bad" field. check the settings for that field, too. you may find that the format needs to be changed on the "bad" field.
Sounds to me like your field is of type number when it should be text.
Wow, so quickly and so accurately. The "as entered" format fixed the problem. Thank you so much.