New Q:

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Thank you all.

Is there a way to show only the results on a form w/o the control source box
as if the answer is part of a text? i.e. There're 78 days left to year end.
 
Thank you all.

Is there a way to show only the results on a form w/o the control source box
as if the answer is part of a text? i.e. There're 78 days left to year end.
Click to expand...

Yes. As I suggested:

Set the Control Source of a textbox to

=DateDiff("d", Date(), DateSerial(Year(Date()) + 1, 1, 1))

This could be used in a Label if you don't want to use a textbox...

John W. Vinson[MVP]
 
Back
Top