Can access display multiline captions in Access 365 form datasheet view?

Question

I have read about using VBA to concatenate terms together using VbCrLf; I personally used Ctrl-Enter to create a second line in the caption field in the properties box.

But, after I do my ctrl-enter, it then only shows the first line of my multi-line caption in the datasheet view of my form.

becomes this...

This form is meant to recreate the functionality our owner is looking for from a current excel spreadsheet (the ability to sort on various columns), so I can't just use a report.

Please tell me I'm missing something obvious such as a caption height property value or something. The multiline caption will be very useful to help maintain appropriate column widths for the data.

Answer 1

There is no solution to adjusting column headers in the specific "datasheet" form that I was trying to use. It's a nice quick way that works for 95% of your uses. But, if you need more control (like me and others on the internet) the only solution is to create the form as a "Tabular" form in the form wizard. There are other descriptions of this type of form in Access (just to be confusing).

This is also described as a continuous form likely because that's the form property value toggle when you dive into the details.

It's more work but you have full control over the size, format, etc. of your column headers when creating/designing a tabular form.

Answer 2

Whilst you can display multiple lines of content within the datasheet view for a table by increasing the row height of each record, e.g.:

A more appropriate solution might be to use a text box on a form to display the data, where the height of the text box can be predefined in the design of the form, and scroll bars can be displayed: