Date or N/A

[fat controller]

Is there a way to allow a field to contain dates or to have N/A if there is no date to be entered?

 

[missinglinq]

Only, I think, by making it a Text Field. You'd then have to use CDate() to convert the data to a Date, before using it in computations/manipulations of any kind, doing so only if the data isn't 'N/A.'

Linq ;0)>

 

[CJ_London]

you should not mix field types in a control as it can confuse access.

you can use the format property for a control to display N/A if null

for numbers (and the date datatype is a number) there are 4 sections separated by a semi colon

positive;negative;zero;null

dates can't be negative or zero so setting the property to

dd/mm/yy;;;"N/A"

will display N/A when null.

You can add some basic colours as well

[green]dd/mm/yy;;;[red]"N/A"

will display valid dates in green and N/A in red

 

[fat controller]

Thank you both

I have paused on this particular part at the moment (holiday mode looming!), but will refer back to this when I am at this point.