Bigger... plusses?

[nac1987]

Sorry, very simple one from a total novice, I've tried to Google, but I don't know the name by which to refer these little plusses you get...

I'm making a form, the form has a table, the rows of the table have a plus next to them, indicating that the linked table's information can be seen if you click it...

All I want to know is, can I make these little plusses bigger? They're a bit small for my liking.

Thank-you and sorry.

 

[CJ_London]

Short answer is no. You could try changing the windows parameters (control Panel > Appearance and Personalisation - but that will affect all applications and I can offer no advice as to whether this is actually doable or would produce the result you want.

Longer answer is you can create your own + as a control (but it is not straightforward to mimic what the access functionality provides), or investigate using a listview active X control. However I am unable to help with either of these options.

The view you are talking about is very basic, and has very limited control and I suspect you will very quickly outgrow it's use as you come to realise its limitations

 

[CSL]

As CJ suggests you could have another button say on the main form which then holds the datasheet and subsheet. On the click of the button it could toggle the subsheet to be expanded or not.

1. With Forms("FormName")
3. strExpand = InputBox("Expand subdatasheets? Y/N")
5. Select Case strExpand
6. Case "Y"
7. .SubdatasheetExpanded = True
8. Case "N"
9. .SubdatasheetExpanded = False
10. Case Else
11. MsgBox "Can't determine subdatasheet expansion state."
12. End Select
14. End With

 

[gemma-the-husky]

not only can you not change the pluses, they are also pointless.

if you take it as a given that no user (except the developer/dbs manager when investigating problems) should EVER use a table directly, there is absolutely no point in the pluses, that I can see.

Having said that, there may be some changes in later versions of access

 

[CSL]

Its doesn't have to be the table directly - it can be a form with a subform in datasheet view, with the recordsource set in a way that's not accessing the table directly.

I thought the above was what the OP was referring to , as they mentioned a form.