Keep calc'd fields blank until command button is clicked

A

angellijah

I have a form that has users input a beginning and ending date, then click a
command button to "view details" that show up on calculated fields elsewhere
in the form. Is there a way to keep the calculated fields blank until the
user presses the "view details" button? I still want the labels to show, I
just don't want any values to show in the fields. I hope this makes sense!
 
K

Klatuu

Rather than putting the calculation in the control's Control Source, perform
the calculations in the button's Click Event.
 
A

angellijah

If I have multiple calc'd fields, would I have to put each fields'
calculation in the button's click event?
 

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

Do Until/Command Button 3
Reference to calc field on sister subform? 1
Prevent printing if required field is blank 2
Command Button Wizard 1
dont save a form's fields until a button is clicked 2
Command Button to Lock Form Fields 3
lock fields in form 2
prevent saving until a button is clicked. 1

Top