I am getting this error (Run-time error '3315': Filed ...can not be a zero-lenght string) when I execute a sub procedure in Access 2000.
My code sets a recordset to a SQL string which pulls a single record in my clients table.
It then attempts to edit that record using a value in a textbox on my form.
I am getting the error EVEN THOUGH MY CODE CHECKS FOR AN EMPTY CONTROL.
The 'Description' field (below example) that which this edit is updating does not have the required property set to YES.
Nor is the control on the form have any restrictions of the like.
It actually used to work fine...now it doesn't...weird.
Here is the sample of code is giving me trouble:
Client = Me.Client_listClient
strSQL = "SELECT Clients.ClientID, Clients.Date, Clients.Company, Clients.Description,"
strSQL = strSQL & " Clients.StreetAddress, Clients.City, Clients.State, Clients.Zip, Clients.Contact,"
strSQL = strSQL & " Clients.OfficePhone, Clients.Ext, Clients.MblPhone, Clients.OfficeFax, Clients.OfficeEmail,"
strSQL = strSQL & " Clients.RevDate, Clients.Ini, Clients.Notes"
strSQL = strSQL & " FROM Clients"
strSQL = strSQL & " WHERE (((Clients.ClientID)=" & Client & "));"
Set rs = db.OpenRecordset(strSQL)
If Not IsNull(Me.Client_ctlDescription) Then 'Not required
rs.Fields!Description = Me.Client_ctlDescription
rs.Fields!Description = Null
.....(more of the same above for different fields)