Data Access Page-Default value

[Shaft]

Hi All,

I've made a data access page which is in data entry mode. One of the fields is a date field which I have set the default value as =Date(), but it only inserts the default value when you move to a new record it doesn't put it in on the initial record.

Any ideas?

Cheers

 

[Shaft]

Hi All,

I've been searching the internet for the resolution but all I've come across is somebody else with the same problem. He explains the problem a bit better then me so heres what he wrote

By default (DataEntry property set to False) the "default value" that
I set for fields in the table work great when creating a new record in
a DAP.

However, I would like this to be a data entry DAP only -- so when I
set the Page DataEntry property to True, the Autonumber at opening is
some huge negative number (-65523) and none of the default value
settings for various fields e.g., StartDate: =date()

What I would like to are the default dates as well as a BLANK
autonumber until the user commits the page.

Any suggestions greatly appreciated

Rob Bollinger

 

[Shaft]

Hi All,

I've managed to get round the problem by setting the default value at table level but this would be unsatisfactory for a lot cases. Very frustrating