Continuous Forms Not Working
By Richard Rost
3 years ago
Continuous Forms Not Working in Microsoft Access
Are you trying to make continuous forms in Microsoft Access and it's not working? In this video I'll show you what the problem is most likely to be, and a quick solution to fix it.
Pre-Requisites
Links
Recommended Courses
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 doesn't display all records, My form or report does not display all of the data
Intro In this video, we'll talk about a common issue where continuous forms in Microsoft Access do not display properly, even after setting the form's default view to continuous forms. I will show you step-by-step how to create a continuous form, highlight typical mistakes beginners make with the Detail section's height, and explain the quick fix to get your forms displaying multiple records as intended. You'll also see tips for customizing form appearance, adjusting section layouts, and managing header and footer sections for better organization.Transcript Welcome to another fast tip video brought to you by AccessLearningZone.com. I am your instructor Richard Rost.
Are you trying to make a continuous form in Microsoft Access and it's not working? I got asked this about three times this week. This is one of the more popular questions that comes up. Let me show you what I see people doing all the time, why it doesn't work, and the real easy fix for it.
All right, so you have yourself a database and you want to make a continuous form like I've got right here. They look pretty and they work well.
Here's what I see a lot of people do: you go to Create, Form Design. The first thing I always do is give my form a splash of color. Let's go with that. Then we go to the form's properties, go to Data, set the record source. In this case, I'll just pick CustomerT. I usually get rid of any filters or order bys that show up in there.
Now we're going to go to Format and we're going to change it from a single form to continuous forms. That means the records should appear one after the other.
Now let's add some fields. We'll go to Form Design, Add Existing Fields. I'll put in CustomerID, FirstName, LastName, and EmailAddress. Click and drag, and we'll get rid of the labels, we don't need those.
I'll put the CustomerID over here, the FirstName next to it, the LastName next to that, and then finally the EmailAddress and make that a little bigger. Everybody's looking good and happy. Let's save this. I'll call this my CustomerNewListWhateverF.
I'm going to close it, open it back up again, and it's not working. I can scroll through the records either with the navigation buttons, or I can scroll up and down with my scroll wheel, but I'm only seeing one at a time on the form.
It's not working. Let's check those properties again: Design View, Form Properties. Yeah, it's set to continuous forms. What's wrong? Why isn't it working? If you know, pause the video and put in the comments right now and tell me what it is.
This is extremely common. I see it all the time with newbies, beginners, people who are just using Access. That's okay, you're here to learn. Here's the problem: this Detail section has a height, and if you scroll down, look at that, it's way down here.
Move your mouse over that border, click and drag, and make it shorter, even shorter, bring it right up there. Now save it, close it, open it up again, and there you go. Now it looks more like a continuous form.
Another thing I don't like is this alternating background color. I think it looks nice on some reports, but I never use it for forms. In here, I'm going to go to the Detail section, click on the header. There's a back color that we just set earlier, and then there's an alternate back color. I'm going to set that to no color and it will just get whatever the color is up here.
In some of my earlier videos, I'd set these to the same thing, but if you change this in the future, you have to remember to change the other one too. If you set it to no color, it just adopts the background color. Save it, close it, open it, there you go.
If you want to bring them right together like mine here, I don't have any spacing between them. That's not hard to do either. In Design View, just come in here, click them all, slide them to the very top of that section. Get them right up next to each other like that, and then drag that bottom up as high as it'll go. You can bring in that right side too if you want.
Make sure if this field is a date field you leave enough room for a little calendar popup if you want that. Save it, close it, open it back up again, and look at that, it's starting to look good.
I don't like datasheet view. I don't like datasheet views because they look too much like tables. I don't like working with these. I prefer the control and the formatting and the VBA-ness that you can get with continuous forms.
One other thing you might want to do is you could turn on the form header and footer. Right-click, there's a Form Header/Footer and a Page Header/Footer.
We don't use the Page Header/Footer because it only shows up when you print a form. But we don't print forms, we print reports, so we're never going to use this.
Form Header/Footer shows up on the screen, and again, here's a section. You can give it a little bit of color if you want to. I usually click on the same color that's in the detail section, then drop this down, go to More Colors, and you can make it a little bit darker. Click down here and make that the same. If you want to put totals or something down here, I have videos for all that stuff.
If you want to put a label up top here, you can go up here, grab a label, drop it right there on top, drag it across. If you move these around a lot, make individual labels for them, but sometimes you can just make one big label: Customer ID (and this can have spaces in it because this is what the user is actually going to see on the screen - we don't put spaces in our field names).
First Name blank space Last Name, and then Email over here. That's all that's good enough. Make it white so people can actually read it.
Again, I pick standard colors. I try not to use the theme colors. This theme can be easily changed and can easily make your database look like garbage.
There you go. There is your customer new list, looks like that. Maybe left align that.
There we go. Save it, close it, open it up, boom, and that's nice and pretty.
That's the number one reason why people's continuous forms don't work the first time - that detail section is too tall. Like I said, I've seen this question three times recently. I get it all the time.
So that is your fast tip video for today. Hope you learned something, and if you have a question like this, no matter how silly you think it might be, send it in. If I like it, I'll turn it into a video.
I'll see you next time. If you enjoyed this video, please give me a thumbs up and post any comments you may have. I do try to read and answer all of them as soon as I can.
Make sure you subscribe to my channel, which is completely free, and click on the bell icon to select all to receive notifications when new videos are posted. Make sure you click the Show More link down below the video to find additional resources and links. You'll see a list of other videos, additional information related to the current topic, free lessons, and lots more.
YouTube no longer sends out email notifications when new videos are posted. If you'd like to get an email every time I post a video, click on the link to join my mailing list.
Even if you don't want to become a member, feel free to donate to my tip jar. Your patronage is greatly appreciated and will help keep these free videos coming. I got puppies to feed.
How do you become a member? Click on the Join button below the video. After you click the Join button, you'll see a list of all the different membership levels that are available, each with its own special perks.
Silver members and up will get access to all of my extended cut TechHelp videos, one free beginner class each month, and more.
Gold members get access to download all of the sample databases that I build in my TechHelp videos, plus my Code Vault where I keep tons of different functions that I use. You'll also get a higher priority if you decide to submit any TechHelp questions to me, and you'll get one free expert class each month after you finish the beginner series.
Platinum members get all the previous perks plus even higher priority for TechHelp questions, access to all of my full beginner courses for every subject, and one free developer class each month after you finish the expert classes. These are the full length courses found on my website, not just for Access. I also teach Word, Excel, Visual Basic, and lots more.
You can now become a Diamond sponsor and have your name or company name listed on a sponsors page. They'll be shown in each video as long as you're a sponsor. You'll get a shout out in the video and a link to your website or product in the text below the video and on my website.
Don't worry, these free TechHelp videos are going to keep coming. As long as you keep watching them, I'll keep making more and they'll always be free.
If you have not yet tried my free Access Level 1 course, check it out now. It covers all the basics of Microsoft Access. It's over four hours long and I just updated it for 2021. You can find it on my website or on my YouTube channel. I'll include a link below that you can click on.
Also, if you like Level 1, Level 2 is just one dollar. That's all, one dollar, and it's free for all members of my YouTube channel at any level, even supporters.
Want to have your question answered in a video just like this one? Visit my TechHelp page on my website and you can send me your question there. While you're on my site, feel free to stop by the Access Forum. Lots of good conversations happening there.
Be sure to follow my blog, find me on Twitter, and of course YouTube.
Once again, my name is Richard Rost. Thank you for watching this TechHelp video brought to you by AccessLearningZone.com. I hope you enjoyed this video and that you learned something today.
I'll see you again soon.Quiz Q1. What is the main reason why a continuous form in Access might not display multiple records at once, even after changing the Default View to Continuous Forms?
A. The form's record source is not set
B. The Detail section is too tall
C. Filters have not been removed
D. There are missing labels for fields
Q2. After setting up your continuous form and adding fields, you only see one record at a time. What should you check first to fix this?
A. Delete all fields and start over
B. Check the Format property and make sure alternating colors are enabled
C. Adjust the height of the Detail section to make it shorter
D. Change the form view to Datasheet
Q3. Why does setting the alternate back color of the Detail section to 'No Color' help with form appearance?
A. It automatically sets alternating row colors to red
B. It uses the same background color as the main Detail section, making design changes consistent
C. It disables all colors in the form
D. It only works on printed reports, not forms
Q4. What is the purpose of the Form Header/Footer option in Access forms?
A. To add extra navigation buttons below the form
B. To display fields in a grid above and below the detail section for printing
C. To provide sections for titles, totals, or labels visible on screen
D. To add conditional formatting automatically
Q5. Why should you avoid using "theme colors" when designing Access forms, according to the video?
A. Theme colors are always blue and cannot be changed
B. Theme colors update automatically, which can make your database look bad if the theme changes
C. Theme colors make forms run slower
D. Theme colors are not compatible with VBA
Q6. What is a recommended use for the Page Header/Footer section of a form?
A. For items you want printed at the top or bottom of every printed page
B. For organizing navigation inside the form
C. For displaying totals only on the screen
D. For exporting data to Excel
Q7. Why does the presenter prefer continuous forms over datasheet view in Access?
A. Datasheet view uses less memory
B. Continuous forms allow better control, formatting, and VBA integration
C. Datasheet view is only for reports
D. Continuous forms can only show one record at a time
Q8. When designing a continuous form, what should you consider if any of your fields are date fields?
A. Use a darker color for date fields
B. Leave extra space for the calendar popup control
C. Center align all fields
D. Only use datasheet view for date fields
Q9. What should you do to ensure there is no spacing between records in your continuous form?
A. Delete some of the fields
B. Increase the height of the Detail section
C. Move controls to the top and reduce the Detail section's height as much as possible
D. Use alternating row colors
Q10. If you want to add a label at the top of your form to describe the fields, where should you put it?
A. Inside the Page Header/Footer section
B. In the Form Header section
C. In the table design view
D. Next to each field in the detail section
Answers: 1-B; 2-C; 3-B; 4-C; 5-B; 6-A; 7-B; 8-B; 9-C; 10-B
DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.Summary Today's video from Access Learning Zone focuses on troubleshooting continuous forms in Microsoft Access. Many users, especially those who are newer to Access, often attempt to create a continuous form but find that it only displays one record at a time, acting very much like a single form instead. This is one of the most frequently asked questions I receive. Let me walk you through what typically goes wrong and how to resolve it with a simple fix.
When you create a new form in Access, you usually begin by opening the Form Design view. I personally like to add some color to the form early in the process to make it visually appealing. After that, the next step is to set the form's Record Source, for example, linking it to a table like CustomerT. I usually remove any filters or sort orders at this point to start fresh.
Changing the form's Default View property from Single Form to Continuous Forms is supposed to allow multiple records to appear, each one underneath the previous, so that you can see several at a glance. From here, I add the fields I want - such as CustomerID, FirstName, LastName, and EmailAddress - typically arranging them side by side for a cleaner layout. Once the fields are arranged and the form is saved and reopened, many users expect to see several records showing at once.
However, at this stage, a common problem occurs: the form still only displays one record, forcing you to scroll using the navigation buttons or mouse wheel to see individual records. This is where most people get stuck, even though the form's properties are correctly set for continuous forms.
The issue lies not in any advanced setting or in the form's format property, but in the detail section's height. By default, the detail section is often much taller than needed. This makes each record take up so much vertical space that only one can be displayed at a time. The fix is straightforward: in Design View, drag the bottom border of the detail section upwards to shrink it closer to the fields you added. The more compact you make it, the more records will show on your form at once.
Once the detail section is the correct size, after you save and reopen the form, you should see multiple records displayed in a nice, continuous list. For better aesthetics, you may want to eliminate the alternating background color. This visual feature is common for reports but is often distracting on forms. In the detail section's formatting properties, you can set the alternate background color to 'no color' so the whole section shares your chosen background. This approach also prevents problems if you ever change the background color in the future.
Another tip to create a cleaner look is to move your field controls to the very top of the detail section and reduce the spacing between records. This gives your continuous form a streamlined table-like appearance, just the way you want it. Be sure to retain enough space for controls that need it, like calendar popups for date fields.
I personally avoid datasheet views for forms. While some users like them, I find them too similar to tables and prefer the enhanced formatting and control continuous forms provide, especially when you want to add custom formatting or use VBA code.
It can also be useful to enable the form header and footer. The form header allows you to add descriptive labels or even simple branding. You can apply consistent color schemes here, perhaps making the header a different shade for contrast. The footer could be used for totals or other summary information if you need it. The page header and footer, on the other hand, are only shown when printing, which is rarely necessary for forms.
Labeling your fields in the header is a good idea for usability. Remember, labels can include spaces, unlike your actual field names, making the form more user-friendly. I recommend using standard, non-theme colors for elements like labels and backgrounds. Applying theme colors can cause design issues if the overall database theme is ever changed in the future.
After adjusting all your formatting and labels, you can save and close the form, reopening it to review the finished result. The most frequent cause I encounter for continuous forms not displaying correctly is simply that the detail section is too tall, so fixing the height almost always resolves the problem.
If you have further questions or if there's something you'd like to see covered, feel free to send your question my way. Whether you think your question is basic or advanced, I accept all sorts. You might even see your issue addressed in a future video.
For more learning resources, you can check out my website, which offers a comprehensive Access Level 1 course absolutely free. If you enjoy Level 1, you can move on to Level 2 for just one dollar or get it for free as a channel member. There are also membership options with various perks, like access to extended videos, downloadable sample databases, and exclusive code collections.
If you wish to show your support, there are options to join as a channel member, donate to the tip jar, or simply subscribe for free to keep getting the latest content. And remember, these tips are always available, with more coming as long as you keep watching.
To find the full video tutorial that provides clear, step-by-step instructions on everything discussed here, visit my website at the link below.
Live long and prosper, my friends.Topic List Creating a continuous form in Microsoft Access
Setting the form Record Source property
Switching from single form to continuous forms
Adding fields to the form from a table
Adjusting the Detail section height for proper display
Removing unnecessary field labels
Customizing the form and control layout
Fixing the alternating background color in the Detail section
Aligning and arranging fields for tight row spacing
Turning on and customizing Form Header and Footer sections
Adding and formatting a label for field headers in the Form Header
Saving and previewing the final continuous form design |
