How to add to 'Common Expressions" in Access?

In Expression Builder dialog of Microsoft Access there is an entry for Common Expressions. Can I add my own expressions to that list?

microsoft-access

JonDrnek

Posted 2009-07-15T13:45:17.003

Reputation: 561

I think there is no clear delineation between the two sites. The bigots over at SO want to treat just about any Access question that doesn't involve code pounding as a non-programming question, despite the fact that the results of what you do in Access with point-and-click usually require significant lines of code in just about any other front-end development platform. I'm not sure these two sites should have an independent existence, but these are meta observations and don't really belong here. – David W. Fenton – 2009-09-25T00:28:16.140

1shouldn't this be over at stackoverflow? – pavsaund – 2009-07-15T13:49:25.457

Answers

From Create an expression:

In the Expression Builder, Access includes some common expressions that you can use for page numbering.

I believe there are only a few such expressions, dealing with page numbers, date/time values and current user. And that you can't add to them.

harrymc

Posted 2009-07-15T13:45:17.003

Reputation: 306 093

I think the "Common Expressions" list is generated by Access as it notices you using certain expressions, well, commonly :)

I believe it's similar to how Excel will eventually change the list of frequent functions you can insert when you go to Insert -> Function.

warren

Posted 2009-07-15T13:45:17.003

Reputation: 8 599