I have a database with a MS Access frontend and an SQL Server 7 backend.

I have a form in MS Access that writes to the sql server.

One of the text boxes on the form combines the data from several others to produce a unique number and looks something like 046-10210-001-A, using a simple expression in the control source of the text box.

The form writes to the sql server with no problems all apart from the text box with the combined data. SQL Server just sees a NULL value.

Anybody know how to make sql server see it ?

Thanks in advance