Unanswered: access combined fields. SQL Server sees null?
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.