How Can I Eliminate the "+" Sign When Displaying Table Data

[Rich Locus]

I created two tables and used the "Relationships" view to create the
relationships. Now, when I just display the table data (double click the
table name) on the One Table (One to Many), it has a plus sign in the left
column that brings in the "Many" table data if I click the + sign.. I could
not find a way to turn off that feature. Is there?

 

[Tom van Stiphout]

On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus

Yes there is, and it is a good idea to turn it off. Design the table,
get properties, and set SubDatasheetName to "[none]".

If you search for these keywords you'll probably find code that will
loop over all tables and turn it off for all.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus

Yes there is, and it is a good idea to turn it off. Design the table,
get properties, and set SubDatasheetName to "[none]".

If you search for these keywords you'll probably find code that will
loop over all tables and turn it off for all.

Here's some (that I got from this group at some point I've forgotten,
apologies to the author):

Public Function TurnOffSubDataSh() As Integer
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim prp As DAO.Property
Const conPropName = "SubdatasheetName"
Const conPropValue = "[None]"

TurnOffSubDataSh = 0
Set db = DBEngine(0)(0)
For Each tdf In db.TableDefs
If (tdf.Attributes And dbSystemObject) = 0 Then
If tdf.Connect = vbNullString And Asc(tdf.Name) <> 126 Then
'Not attached, or temp.
If Not HasProperty(tdf, conPropName) Then
Set prp = tdf.CreateProperty(conPropName, dbText, _
conPropValue)
tdf.Properties.Append prp
TurnOffSubDataSh = TurnOffSubDataSh + 1
Else
If tdf.Properties(conPropName) <> conPropValue Then
tdf.Properties(conPropName) = conPropValue
TurnOffSubDataSh = TurnOffSubDataSh + 1
End If
End If
End If
End If
Next

Set prp = Nothing
Set tdf = Nothing
Set db = Nothing
End Function

 

[Keith Wilby]

On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus

Yes there is, and it is a good idea to turn it off. Design the table,
get properties, and set SubDatasheetName to "[none]".

If you search for these keywords you'll probably find code that will
loop over all tables and turn it off for all.

You also need to turn off name auto-correct, else the dreaded [Auto] will
return

Keith.
www.keithwilby.co.uk

 

[Keith Wilby]

Here's some (that I got from this group at some point I've forgotten,
apologies to the author):

I think it was Allen Browne.

 

[Jeff Boyce]

Rich

Other's have pointed to how you can turn off that 'feature'.

Please also be aware that Access tables are intended to store data, not
display it. You and your users don't need to (and probably shouldn't) work
directly in the tables.

Use Access Forms instead.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.