Hi

I have a database field which is a text field but it is mainly for holding phone numbers (made it a text field so people could leave something like Thailand 1234 123456), the problem is that Access keeps stripping out the leading zeros when it inserts the record so that 01977 123456 becomes 1977 123456.
Is there a way round this or shall I simply change it to a numerical field?

Thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

I've discovered that it wasn't access it was an extension that I was using to validate the form.
Removed the extension and now the leading zeros are left intact.

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome