By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,825 Members | 2,437 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,825 IT Pros & Developers. It's quick & easy.

Default Design values

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

P: n/a
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.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.