Have a problem that has me swinging.

I have a MS Access d/b that contains a zip code directory. Updates are done
via a web-based ColdFusion form.

Initially, the zip code fields were number fields. This type prevented a
leading zero from being displayed, so I changed the data type to text and the
problem was solved. Or so I thought.

When a record containing a zip code with a leading zero is updated via the
web-based form, the leading zero disappears. I can edit the record, add the
leading zero, update, and the newly re-entered leading zero is not accepted.

I posted this dilemma to a web discussion list, which pointed out the input
mask function in Access. Added a input mask for zipcode. Didn't solve the
problem.

Any ideas?