Expression Builder available in Code Builder?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 .
 
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.
 
Back
Top