G
Guest
I have an IP address field in my table. There is already existing data.
What I would like to do is pad the existing data with zeroes so that for
example 10.1.104.3 would be 010.001.104.003. Is there a good way to do this
with Access or will I have to export the data and do something else? Also, I
want to add a mask to this field so that any new addresses are entered the
way that I want. What would be the best way to do this and will adding a
mask now affect the existing data? Thanks. Matt
What I would like to do is pad the existing data with zeroes so that for
example 10.1.104.3 would be 010.001.104.003. Is there a good way to do this
with Access or will I have to export the data and do something else? Also, I
want to add a mask to this field so that any new addresses are entered the
way that I want. What would be the best way to do this and will adding a
mask now affect the existing data? Thanks. Matt