Formatting dates textBoxes

[tziviak]

I have a report that Has date fields. The first Date field-is taken from the control source of the page-where the user enters the date using the [] in the query.
Now, I have 14 other little text boxes where I want the day of the month -and it should keep on increasing.
Ex. if the user enters 7/9/03 then:
the results should be in the 14 text boxes:
1. 9
2. 10
3. 11
4. 12
and so on...

I tried putting in properties of the textboxes-in the format section d (for day) and in the control source: =[FirstBillingDate]+1
But I get an #error

any help would be appreciated.

 

[jrbarnett]

Hi,

To obtain the day of the month, put a text control on your report with the controlsource:
=Day(Datefield)

If you name this textbox txtFirstbillingdate, you can then create a second textbox called txtSecondbillingdate with the controlsource =txtFirstbillingdate+1, and so on.

John

 

[tziviak]

I tried it and I'm still getting #error

 

[jrbarnett]

Do you get the correct number in the first textbox?

John