expression builder in acces 2000 or 2002

[MikeConig]

Hi,
I've created several databases in access 97 and when you go to a form and create a new button and select code builder it would open up vb module. From within that module you had an option if you were to right click on the screen to open the expression builder to build your string. Lets say that you wanted to make a control not visible on a subform, I would right click in the module choose Build... choose loaded forms > main form > subform > choose my control then choose visible, click ok and it would put the line in my vb module with the proper syntax. What happened to that option in Access 2000 and above.

Thanks in advance

Mike

 

[fredg]

Hi,
I've created several databases in access 97 and when you go to a form
and create a new button and select code builder it would open up vb
module. From within that module you had an option if you were to right
click on the screen to open the expression builder to build your string.
Lets say that you wanted to make a control not visible on a subform, I
would right click in the module choose Build... choose loaded forms >
main form > subform > choose my control then choose visible, click ok
and it would put the line in my vb module with the proper syntax. What
happened to that option in Access 2000 and above.

Thanks in advance

Mike

Mike,
Not sure about Access 2000, but in Access 2002:
Click on any EMPTY event line.
Click on the button with the 3 dots that appears.
Select the Expression Builder.
Use the builder to write your expression.
Click OK.
The expression will be pasted onto that event line.
Highlight the expression.
Cut it.
Click on the event that you wish to place the expression in.
Write [Event Procedure] on that line,
Click on the button with the 3 dots that will appear.
Paste your expression into the code window.

 

[Douglas J. Steele]

Take a look at TSI Xpression 9.0, a free replacement from Michka:
http://www.trigeminal.com/utility.asp?ItemID=1#1

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hi,
I've created several databases in access 97 and when you go to a form and

create a new button and select code builder it would open up vb module. From
within that module you had an option if you were to right click on the
screen to open the expression builder to build your string. Lets say that
you wanted to make a control not visible on a subform, I would right click
in the module choose Build... choose loaded forms > main form > subform >
choose my control then choose visible, click ok and it would put the line in
my vb module with the proper syntax. What happened to that option in Access
2000 and above.