Field is auto populating with next available data when it should be blank

[Huddle]

I am using this formula in a field. =[DO_First].[column](2) & " x" & [DO_First].[column](3) When the data in the table is blank it is populating with the next available data. I don't want this I want it to stay blank. I think there is something in the properties that needs to be switched but I don't know what. Can you help?

[CJ_London]

sounds like DO_First is a combo or list box. Form your field to be blank, you must have not selected anything in DO_First

[Huddle]

But in the table column 2 associated with DO_First is blank. Why would it not fill in the field as blank?

[CJ_London]

just to check - column numbers start from 0 - so column(2) is actually the third column

[Huddle]

That is correct

[CJ_London]

I think I have just twigged - is this a calculated field in a table, or a control on a form?

[Huddle]

Control on a form. I changed the controlling field and I think I have it working right now. Thanks for your help.

[ItsMe]

Also, what is "blank"? Assigning Null to a variable can give undesirable results. It seems you are using the control and its properties to manage this. I would recommend using VBA. Another approach may be to filter your recordset to not display Null values.