How to Let Users Change the Row Height in a Microsoft Access Continuous Form

In this Microsoft Access tutorial I am going to teach you how to allow your users to change the height of the rows in a continuous form to their liking.
Nancy from Bremerton, Washington (a Platinum member) asks: Is there a way to allow my users to change the height of the rows in a continuous form? Some of my users like them small so they can see more records. Others like them bigger so they can see more info in each field (especially for long text fields). I tried using a split form, but they don't seem to hold their properties.
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Chan...
PREREQUISITES:
Intro to VBA: 599cd.com/Intr...
LINKS:
Microsoft's Form Sections Page: tinyurl.com/27...
User Level Security 1: 599cd.com/User...
System Defaults: 599cd.com/Syst...
RECOMMENDED COURSES:
Access Developer Courses: 599cd.com/Deve...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Continuous form height, row height, continuous form with differing row heights, continuous form with different row heights, Row height on continuous form, split form
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@renoholland7090]

Very cool. I had never thought about that,

[@Shadow.Dragon]

Richard, thanks for the video! While Batman and Robin were great, it was Alfred that was the real star of the show! LOL!!! JK!

[@Harraz1969]

Hello sir,
Do you have videos in explaning treeview

[@khizarshazad4924]

I have a question. Sir I have require 4 digit number format in Ms access. It work in the table but it's can't work in form. E.g I have to write number 0001 , it works in table but in form it's only fetch 1 without preceding zero. How the problem can be solved

[@MvdBergh100]

In Microsoft Access forms, the display format of a numeric field can be controlled using the "Format" property. To ensure that the 4-digit number format with preceding zeros is displayed correctly in the form, you can set the "Format" property for the textbox control that is bound to the numeric field.
Here's how you can do it:
Open the form in Design View.
Select the textbox control that is bound to the numeric field (the field where you want to display the 4-digit number with preceding zeros).
Open the Property Sheet by pressing F4 or right-clicking and selecting "Properties."
In the Property Sheet, navigate to the "Format" property.
Enter the format code "0000" in the "Format" property.
The "0000" format code specifies that the value should be displayed with four digits, and if the value has fewer digits, it will be padded with preceding zeros to make it four digits.
Save the form.
Now, when you enter or view the value in the textbox on the form, it should display the 4-digit number with preceding zeros, just like it does in the table.
For example:
If the value in the table is "0001," it will display as "0001" in the form.
If you enter "1" in the form, it will be automatically displayed as "0001" once you move to another control or save the record.
The "Format" property only affects the visual representation of the data in the form and doesn't change the underlying data in the table. The data will still be stored as "1" in the table, but the form will display it with the desired format using the "Format" property.