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

[FORM DATES]

HOW ALL DAYS OF A MONTH WILL BE RESULT WITH TEXT BOX IN FORMS

 

[fredg]

HOW ALL DAYS OF A MONTH WILL BE RESULT WITH TEXT BOX IN FORMS

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.

 

[KARL DEWEY]

Huh?

 

[John W. Vinson]

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

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???