Handling Run-time error '2427': You entered an expression that has no value

[dexterwolf]

I get the title message and then asks to Debug. I debug and the second line is highlighted below. Anyone have any ideas as this has just stopped working in Access 2003. Thanks for any help



Private Sub ObjName_Enter()
If Me.code = "" Or IsNull(Me.code) Then
Me.ObjName.Locked = True


Else
Me.ObjName.Locked = False
End If
End Sub

[ItsMe]

I believe code is a reserved word. Do you have a control or a field in a table with the name, "code"?

[dexterwolf]

Thanks for coming back to me.

In the data view the only thing I have with code is Church Code.

[John_G]

So what you need then is something like this:

If Me![church code] = "" Or IsNull(Me![church code]) Then ...

Note that I changed Me. to Me! to refer to the form control. Most of the time using Me. (with the period) works, but there are times when you have to use Me! (with the !); it is good practice to always use the ! when referring to form controls or recordset members.

If "Church Code" is not the name of a form control, but it is a field in the form's underlying data, then just use [Church Code], without the Me.

[ItsMe]

I always thought it was the opposite. That using Me with the bang was accessing the Field within the form's recordset and the dot operator is best used for accessing members other than the default member. So, use the dot access operator to access Controls.

Me.ControlName and Me!FieldName

.

[John_G]

A quick internet search on this shows that the general consensus is that ..... there isn't one.

I try to use ! for form controls or recordset members, and dot for properties and methods. I have found as MS Access has evolved, it has gotten more and more fussy about which is used when - but maybe that's just me. (or is it just me!) ?

[June7]

I use dot to invoke intellisense popup tips in VBA - controls will be listed. Use bang for recordset fields and when using classes, like: Forms!formname.controlname

[ItsMe]

A quick internet search on this shows that the general consensus is that ..... there isn't one.

I definitely agree with that.