Page 1 of 1

Default size Varchar field

PostPosted: Sat Jan 02, 2021 5:17 am
by FKlusmann
Villeroy wrote:By default this setting is 1930. This is the setting which determines if 1/1/30 is meant to be in 2030 or 1930. It does not impose any limit to the entered date.

You always set me straight. Thank you and Happy New Year!

An off-topic question: LO, when creating a table in Design View, defaults the length of Text[VARCHAR] to 100. Is there a way to change this to 35? Thanks again for all your help.

 Edit: Split from Date field changing as this is a different question.
Please start a new topic for a new question.

Re: Default size Varchar field

PostPosted: Mon Jan 04, 2021 8:04 pm
by Villeroy
I don't know. I write my tables in SQL because it is easier.