I have a form, which has a control with a Default Value. I need to hide this value or make it null, if the value of another control is also null. Both are text fields.
ie, Checklist has a default value of "Xray". If [Cast No] is blank, I don't want "Xray" to appear. I've tried all sorts of code, but nothing has worked, and I wondered if it was because I had set the default value in the table.

Try something like the following for the form's BeforeUpdate event:

Can't seem to get that to work either.

Any error?

If not, are you sure that the code is running?

I've been making some changes to the database, which meant some control names changed. The control names are now Cast_No_2, which replaces Cast_No, and Others_2, which replaces Checklist. This is the code I have


The control Others_2, does appear blank, but only for 1 record, and on leaving the form, I get an error saying Microsoft Office Access can't find the field 'Others_2', and asks me if I want to debug. If I just select 'End', I am taken back to the form, and the control 'Others_2' is blank. What I'm trying to achieve is, if Cast_No_2 is blank, so is Others_2, if not, the default text should appear.

You certain you've got the names of the controls properly?

FWIW, I've always considered it a very bad idea to include special characters (which includes spaces!) in the names of fields or controls.