0

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.

enter image description here

becomes this...

enter image description here

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.

jimm
  • 33
  • 9
  • Sorry, not possible. – Gustav Nov 24 '20 at 17:01
  • I'm pretending I didn't see your answer! Ha! In all seriousness, care to elaborate as to why? It seems odd to allow multiline data in the property and then do nothing with it. – jimm Nov 24 '20 at 17:19
  • Can't tell why. It's by design. – Gustav Nov 24 '20 at 17:28
  • Well, I know I couldn't figure it out. Maybe someone smarter than us can hack the system. Thanks for your input! – jimm Nov 24 '20 at 17:53
  • Increase the height(size) of your row by resizing it at the row headers. If you click on `Save` in Datasheet view it will save the height adjustment. Unfortunately, I know of no way to display scroll bars, or notify the user visually that there is more data following in the data cell if you happen to have random line counts. – jbud Nov 24 '20 at 19:09
  • 1
    From what I've tried and read you can't adjust the row headers in a datasheet form view in Access. It's one of the limitations of the specific "Datasheet" form. The solution is to create a tabbed form which takes more work but gives you more granular control over your setup. – jimm Nov 24 '20 at 20:06

2 Answers2

0

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.:

enter image description here

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:

enter image description here

Lee Mac
  • 15,615
  • 6
  • 32
  • 80
0

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.

jimm
  • 33
  • 9
  • 1
    *This is also described as a continuous form* -- that's the official name. Just for future searching purposes. – Andre Nov 25 '20 at 06:45
  • Thanks Andre. That's why I included "continuous form" in my comment above. I'm new enough I didn't realize they were the same thing until a lot of reading. Hopefully that's enough to catch a search and lead someone here. There were enough people asking around the web that it should be useful. The "datasheet" form is fantastic if you just need a quick continuous form. But, it didn't take me too long to edit a "tabular" form and I could control/tweak a lot more features fairly easily. – jimm Nov 25 '20 at 14:34
  • Actually I meant for *your* future searches. :-) -- I don't think I have seen the term "tabular form" anywhere. – Andre Nov 25 '20 at 17:39
  • That's the term used by Access in their Form Wizard. You can select "Tabular" as one of the options. It's also how many of the tutorials referred to it. However, as you say, it's more commonly called "Continuous" and that's what kept coming up as a solution in my internet searches. "Use a continuous form" only I didn't know what that was! Now I know. So that's why I was thinking the other way around for searching. It took many links to find someone that connected "tabular" and "continuous" so I knew they were essentially the same thing. – jimm Nov 30 '20 at 13:30