Expression Builder available in Code Builder?

[Frank77]

I've just upgraded from Access 97 to XP. It seems that in the VBA Code
Builder I can't launch the Expression builder. In Access 97 a right button
click would pop a menu with the Build ... selection which launched
Expression builder. I found Expression builder very helpful in creating the
properly qualified Form field names syntax.

Is there a way to launch Expression builder when writing VBA code? or some
equivalent way to generate properly qualified field names?

 

[Brendan Reynolds]

The expression builder no longer works in the VBA editor in Access 2000 or
later, but Michael Kaplan has a (free) add-in to restore it in Access 2000
or 2002 (I don't know whether it works in 2003)

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=1#1

 

[Frank77]

Thanks ... worked like a charm for me in XP. I don't understand why
microsoft changed this around. On MK's site he hasn't updated his comment on
likely unsupported results beyond 2000 and XP. For 2003 I suppose the low
tech solution would be to compose with Expression builder in an environment
that allows it (such as a Module Event ) then cut and paste your composition
into VBA ... an ugly way to get valid field syntax .

 

[Brendan Reynolds]

I believe the loss of the Expression Builder in Access 2000 and later was a
consequence of the separation of the VBA IDE from the main Access window.
Beyond that, I can't say, I don't use the Expression Builder any more
myself.