#Name error in Access 2010 form

Discussion in 'Computing and Networks' started by stellarpower, Oct 8, 2010.

  1. stellarpower

    stellarpower Thread Starter Member

    Feb 19, 2009
    Hi, can anyone help me with an error I get in access 2010?

    I'm trying to create a form, and in the expression for the value of the box, I want to reference fields using
    Column 1
    ![Field] or
    Column 1
    .[Field] syntax to avouid confusion. However. when I try to do this, I get a name error, even though it seems fine wirth the expression builder. The functions work fine if I just use the field name, and each field has a unique name.