Calculated controls

T

Tony Williams

Is there anyway to search through an Access database and list the names of
all controls on forms and reports that are calculated rather than specified
fields in a table?
Thanks
Tony
 
J

John Spencer

Yes and No.

If the value is calculated in a query then I can't think of a way.

If the value is calculated in the control then you would need to write VBA
that would step through all the controls on forms and reports and look for an
equal sign at the beginning of the control source. Of course, you would need
to only check those controls (text boxes and comboboxes and ?) that do have a
control source property.

This would also miss those controls that were unbound (blank control source
property) and got values assigned via VBA code.

I don't have such code available.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 vs 2010 1
Calculated field in a table 6
Calculated Controls Nz IIf 7
Using a variable to select a form name. 2
Ensuring uniform control width on forms and reports 5
Calculating a field based on other fields in a form... 1
Create formula for "Total Hours" field 1
Calculated Fields 3

Top