CODEWITHSUNDEEP
ms-accessms-access-2010
acr_scout
acr_scout

Reputation: 579

Change MS Access 2010 subdatasheet name default to [NONE]

Is there a way to set the default value for tables "Subdatasheet Name" to [None] instead of [Auto]?

Upvotes: 2

Views: 1022

Answers (1)

HansUp
HansUp

Reputation: 97131

SubdatasheetName is a user-created property, which means the property does not exist in the TableDef.Properties collection until you assign a value to it. When that property has not been set, Access uses "[Auto]", and there is no way to make it use something else as the default value for the property.

You could use VBA to CreateProperty("SubdatasheetName", dbText, "[None]") for each of the local tables in your database. However you would need to do that again for any new tables you create.

Allen Browne discussed this topic in greater detail at Problem Properties. That page includes code you can use to set SubdatasheetName to "[None]".

Upvotes: 4

Related Questions