Form Date issue

[charles.kendricks]

I have a form which has colums for each day of the week (Sun - Sat). I
want to place the date for each day in a row under the column header
for each column. I placed a row of unbound text boxes underneath the
row containing the days of the week. I placed a prompt in the first
day of the week so that It will ask me for the date, which I enter in
the format mm/dd/yy. How do I make the remainder of the text boxes in
that row automatically display the proper respective date. I thought I
could do something like "=[text472] + 1" for the next box in the
sequence if [text472] contains the prompt for the date of the first
date in the week. but that doesn't seem to be working.

 

[Guest]

Hi Charles -- It sounds like you want to make a calendar, which there is a
built-in control for. Anyhow, the format you are using should work; I tested
it to make sure. Did you set the format of the main textbox?

 

[Ron2005]

You need to set the format of both boxes to shortdate.