Digital Workshop

Hi,
I have created a connection using Opus to a local access database. I have 4 pages Add, Search, View and Update.
Some of the text input boxes I'm using on the add a record page will not always need to be filled in. If one or any of the text input boxes are not filled in I receive a error stating this box cannot contain 0 string. the addition is not submitted. Can I do some thing to the text input boxs to allow me to add a record even if a input box is not filled in? Thanks for any help.

I think this may be related to your database not being able to have an empty string? have you put some kind of constraint on the entry in access?

If you have a text input in Opus, you have to allocate a variable to it, so I don't think it will return a null, just an empty string


One way you can test.......is to edit the variable for the text input, give it a default value, either a number or text. it will return the default value (assuming you don't clear the entry first).
If you edit a variable, remember to hit the APPLY button otherwise it won't do the change. An altarnative is to test if nothing has been entered in the text entry, then substitute the empty string for "ABC123" or anything you know is a valid entry.?