I have a live database that I need to change a data type from number to text. (in order to keep leading zero's...if there is a better way, I'd love to hear it ) It says (Access XP) that I can't change the data type because it is part of one or more relationships. However, the relationships window shows NOTHING (doing a show all). Any ideas?
1. are you using linked tabled? maybe references are defined in the linked db.
2. you really should not convert to text to get leading zeros
use the format property/function instead. lets say you want to print at least 5 digits, your format would be 00000 and the function would look like format(MyNumber, "00000").
Thanks guys. The formatting worked. I didn't realize you could type over the entries in the drop-down box for format. I was trying to use the input mask...which worked until you tabbed out of the field.