how a month to retrieve its days from 1st to end of that month

  • Thread starter Thread starter FORM DATES
  • Start date Start date
HOW ALL DAYS OF A MONTH WILL BE RESULT WITH TEXT BOX IN FORMS
Click to expand...

Sorry, but your question is confusing and incomplete.
Perhaps you wish to know how to determine how many days there are in a
month. If so what month? How does Access know which month? Which year?

Let's assume the current month.
You can use the DateSerial function. Look it up in VBA help files.

The day 0 of the following month will tell you how many days there are
in the current month.

=DateSerial(Year(Date()),Month(Date()) + 1,0)

Change Date() to a field name [DateFieldName] if you want the number
of days in the month of a date stored in a date field.
 
On Tue, 16 Mar 2010 22:36:01 -0700, FORM DATES <FORM
HOW ALL DAYS OF A MONTH WILL BE RESULT WITH TEXT BOX IN FORMS
Click to expand...

Please post a comprehensible question. Turn off your CAPS LOCK please, all
caps is hard to read and looks like you're shouting.

Explain what data you have in the form's recordsource and what you want to see
- thirty-one textboxes with dates, or what???
 
Back
Top