Keep calc'd fields blank until command button is clicked

  • Thread starter Thread starter angellijah
  • Start date Start date
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!
 
Rather than putting the calculation in the control's Control Source, perform
the calculations in the button's Click Event.
 
If I have multiple calc'd fields, would I have to put each fields'
calculation in the button's click event?
 
Back
Top