J
JB
Hi,
I have created a Microsoft Access 2000 database frontend, that connects to a
SQL Server 2000 backend. I have a binded form that pulls data from the
backend, and shows it on the frontend. This form also allows updating.
The form has no event procudures, with no code associated with it so its
nothing to do with the VBA side.
Everything is working fine, except when a user tries to update a number
within the textbox. If a number gets updated, it removes the entire string
in that field, not just the number. This issue does not happen if you are
adding new text / numbers or updating text only.
Has anyone heard of this before, and know any work arounds?
I have created a Microsoft Access 2000 database frontend, that connects to a
SQL Server 2000 backend. I have a binded form that pulls data from the
backend, and shows it on the frontend. This form also allows updating.
The form has no event procudures, with no code associated with it so its
nothing to do with the VBA side.
Everything is working fine, except when a user tries to update a number
within the textbox. If a number gets updated, it removes the entire string
in that field, not just the number. This issue does not happen if you are
adding new text / numbers or updating text only.
Has anyone heard of this before, and know any work arounds?