I have a search which generates a table “Found”. I wish to vary the width of one of the fields [Title] in Table display (NOT form or report), using VBA. How do I use Docmd.Setpropertywidth? I can’t figure out the syntax from what the help files display.
DoCmd.SetProperty Tables![Newfound]!Title, acPropertyWidth = 3000
gives Runtime error 424
Object required
DoCmd.SetProperty Title, acPropertyWidth = acPropertyEnabled, 3000
gives Runtime error 2498
An expression you entered is the wrong data type for one of the arguments
DoCmd.SetProperty (Title, acPropertyWidth = 3000)
gives Compile Error:
Expected: =
I just want it to set the width of the table column “Title”
Michael Colley is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
0