Default Design values

[Jan Vente]

Dear listmembers,

Is it possible to change default values in the table design view.
for example: De default value for the fieldsize of a textfield is 50. Could
I change that value by default.
I don't refer to de default property of a field, but the startvalues in the
designenvironment of a table.
I suppose that there is a sort of a designtemplate or a masterdatabase of a
registry key with the startvalues.

Thanks,

Jan Vente
The Netherlands

[Allen Browne]

Under:
Tools | Options | Tables/Queries
you will find the values that can be changed, and yes, you can set the
default size for a new Text field.

Unfortunately, the choices are very limited.
You cannot set AllowZeroLength, which is inconsistent across versions.
You cannot remove the zero as the Default Value for numeric fields.
You cannot set SubDataSheetName to "[None]".
What we do is run a piece of code to tidy up these properties after the
basic design is complete.

When you create a new table, you probably want Design View instead of the
Datasheet View that Microsoft set as default. Although there is no way to
change that in the interrface, it can be done with a registry hack. Go to:
HKLM\Software\Microsoft\Office\
Select your version. Continue to:
Access\Wizards\Table Wizards\Datasheet View
Right-click Index (right pane), and Modify the Value to 1.
Then select Design View, and set its Index Value to 0.

For suggestions on creating default forms and reports, see:
http://allenbrowne.com/ser-43.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jan Vente" <Ja*@abc.nl> wrote in message
news:40***********************@diablo.nl.easynet.n et...

Dear listmembers,

Is it possible to change default values in the table design view.
for example: De default value for the fieldsize of a textfield is 50. Could I change that value by default.
I don't refer to de default property of a field, but the startvalues in the designenvironment of a table.
I suppose that there is a sort of a designtemplate or a masterdatabase of a registry key with the startvalues.

Thanks,

Jan Vente
The Netherlands

[Jan Vente]

Thanks,

Jan Vente
"Allen Browne" <Al*********@SeeSig.Invalid> schreef in bericht
news:40***********************@freenews.iinet.net. au...

Under:
Tools | Options | Tables/Queries
you will find the values that can be changed, and yes, you can set the
default size for a new Text field.

Unfortunately, the choices are very limited.
You cannot set AllowZeroLength, which is inconsistent across versions.
You cannot remove the zero as the Default Value for numeric fields.
You cannot set SubDataSheetName to "[None]".
What we do is run a piece of code to tidy up these properties after the
basic design is complete.

When you create a new table, you probably want Design View instead of the
Datasheet View that Microsoft set as default. Although there is no way to
change that in the interrface, it can be done with a registry hack. Go to:
HKLM\Software\Microsoft\Office\
Select your version. Continue to:
Access\Wizards\Table Wizards\Datasheet View
Right-click Index (right pane), and Modify the Value to 1.
Then select Design View, and set its Index Value to 0.

For suggestions on creating default forms and reports, see:
http://allenbrowne.com/ser-43.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jan Vente" <Ja*@abc.nl> wrote in message
news:40***********************@diablo.nl.easynet.n et...

Dear listmembers,

Is it possible to change default values in the table design view.
for example: De default value for the fieldsize of a textfield is 50. Could

I change that value by default.
I don't refer to de default property of a field, but the startvalues in

the

designenvironment of a table.
I suppose that there is a sort of a designtemplate or a masterdatabase

of a

registry key with the startvalues.

Thanks,

Jan Vente
The Netherlands

[Allen Browne]

Under:
Tools | Options | Tables/Queries
you will find the values that can be changed, and yes, you can set the
default size for a new Text field.

Unfortunately, the choices are very limited.
You cannot set AllowZeroLength, which is inconsistent across versions.
You cannot remove the zero as the Default Value for numeric fields.
You cannot set SubDataSheetName to "[None]".
What we do is run a piece of code to tidy up these properties after the
basic design is complete.

When you create a new table, you probably want Design View instead of the
Datasheet View that Microsoft set as default. Although there is no way to
change that in the interrface, it can be done with a registry hack. Go to:
HKLM\Software\Microsoft\Office\
Select your version. Continue to:
Access\Wizards\Table Wizards\Datasheet View
Right-click Index (right pane), and Modify the Value to 1.
Then select Design View, and set its Index Value to 0.

For suggestions on creating default forms and reports, see:
http://allenbrowne.com/ser-43.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jan Vente" <Ja*@abc.nl> wrote in message
news:40***********************@diablo.nl.easynet.n et...

Dear listmembers,

Is it possible to change default values in the table design view.
for example: De default value for the fieldsize of a textfield is 50. Could I change that value by default.
I don't refer to de default property of a field, but the startvalues in the designenvironment of a table.
I suppose that there is a sort of a designtemplate or a masterdatabase of a registry key with the startvalues.