No expression builder in Access 2007 ADP form

[Allen_N]

I was fairly running with Access 2003, but since Office 2007 was forced upon
me I'm back to crawling.

I've been trying to build a form (in an ADP project) that summarises data
from various tables on the SQL Server. I created a blank form and added text
boxes to show the rresults. When I select a text box, there is no Expression
Builder button in the Control Source field of the Properties drop-down; I
can't get the thing to accept my SQL, either.

Setting the Record Source of the form to the required column makes no
difference.

I know I'm rusty, but Access 2007 seems a lot harder to work with than 2003,
and Help is profoundly unhelpful. (What happened to 'context-sensitive',
Microsoft ?)

Am I missing an important step?

Any advice will be gratefully received.

- Al

 

[AccessVandal via AccessMonster.com]

That's odd, even in access 2000 ADP the control does not have the expression
builder. Did Access 2003 really have expression builder included?

You can use the Access Query builder to create the SQL string than cut and
paste it into the control or use any text editor like notepad.

 

[Allen_N]

Thanks, AccessVandal.

Does this mean I'm confusin features between MDB and ADP ?

(N.B. The Help topic that came up goes on about the expression builder, but
I didn't see any mentioin that it is restricted to MDB's.)

 

[AccessVandal via AccessMonster.com]

Yes, a textbox control in an ADP does not have an expression builder but an
MDB have the expression builder.

Help might have refered to another control like “ListBoxâ€, “ComboBoxâ€, etc.

When you create an ADP in 2007, the Wizard for ADP is not avialable as in
older version. You’ll have to select the format in the combo list. If you
miss this action, you’ll create a wrong format type.