Problems with default value in MS Access 2007
Posted on 2009-04-22
I have create a DLookup for a list box field where I manually typed the values, so it's a static choice list. I want to set the default choice to be the first value I typed in or the first one that shows up on the list. According to Microsoft, this is the way you do that. [control name].ItemData(0). The problem is that Access keeps adding brackets around Item.Data when I leave the default value field. I watch it happen right in front of my eyes, and then, Access rejects the formula as invalid when i go to save the table in Design view and it rejects a formula with brackets that I never added and instead it added for some unknown reason. To make sure I was using the right control name, I went to my form, right clicked the control and got it's properties and read it's name. It's the same name as it's field name, so I think I'm using the right control name. Has anybody else seen this weirdness?