Datasheet in a form view

I know a little about access and have been asked to maintain a database.

I have a form that when I open from the switchboard it opens in “Form” view but looks like a “datasheet” view only with nice heading etc.
When I switch to datasheet you get the standard display.
Looking in design mode I can not see the “grid”. All  the database fields are on there as individual fields
How is this achieved?
LVL 14
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Open the form in design view.  Open the properties window (Att-Enter).  Select the format tab.  Change default view from datasheet to another setting.  Make sure allow datasheet view, allow form view, etc. are all yes.  Save and retry.
Here are some excellent references for learning Access.

Go to Access help>contents>Getting started with Microsoft Access>Get started with Microsoft Access 2000>Using a database for the first time.  If using Access 2002+, Just enter "Using a database for the first time" into the help window.   That is a good way to get started.

You can enter "Training" in Access help to get listings of training options.

Here are a bunch of free or low cost tutorials on learning Access:

Beginner to Intermediate :
34 Free lessons on Access and other links:

18 Free lessons on Access:

Links to Free MS help like explanations of various procedures, properties, etc. from the horse's mouth:

13 Free multimedia lessons on Access

14 Free multimedia lessons on Access

1 free cd or 14 free days online

9 Hours of Interactive Training $99 for DVD

Beginner to Advanced:
Free  lessons on Visual Basic For Application and other links:

Free trials, $149/year for all lessons
daveslaterAuthor Commented:
Hi thenelson

Hi the default setting is form, which is what i want. But the cleaver thing is that it shows a type of datasheet, but much nicer than theMicrosoft default.

Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Sorry, I misread your question.

You want the continuous form to look like the spreadsheet with grid lines between the controls.  Highlight all the controls.  Goto format, align, left to bring them all together and then set the borders to solid.

Is that what you are needing?
daveslaterAuthor Commented:
No. It is like that but it has multiple records based on some slection criteria.


Day     Start     End   Code1   Code2   Code3   Comment
Mon    10:00    11:00  DS       D2        D5        machine OK
Mon    11:00    12:00  DX       D3        D3        Tool mis
Mon    12:00    13:00  DZ       D5        D4        machine OK
Mon    13:00    14:00  DT       D2        D5        machine OK

the selection criteria would be Mon, and the table/query would contain fields
"Day     Start     End   Code1   Code2   Code3   Comment"

does that make it any clearer.
No, sorry, it is not clearer.
I think you have a continuous form (the records are displayed vertically) but I don't understand what you want to do with it after that.

Take a look at Simulate Combobox in Report Form Tricks at  The drop down form is a continuous form designed to look like a datasheet with headings.  Is something like that what you are wanting?
daveslaterAuthor Commented:
sorry for my inability to rexplain.

please look at this link. The top image is the form and the second the datasheet and the last the design view

I looked at your image but I am still at a loss of what you are wanting.  I have carefully reread your question and your posts and see that you are "Looking in design mode I can not see the “grid”. "  Are you wanting to modify the spreadsheet view?  The spreadsheet is modified directly in the spreadsheet View.  Or do you want to turn on the design grid?  That's view menu, grid.  Perhaps if you explain what you want to ultimately accomplish, I might better understand.

I hope you are not getting frustrated.  I am trying to help, but I don't understand what you want that is different from what you have now.
daveslaterAuthor Commented:
I just want to know hoe to achive the form view
daveslaterAuthor Commented:
I do not understand how the design view gives the spreatsheet vew!
The data sheet view is some what independent of the design view which is mostly for designing the form view.  The controls displayed in design view will limit what fields are displayed in data sheet view although you can hide columns in spreadsheet view by dragging the right margin of a column to the left.  You can also rearrange the order of the columns in the spreadsheet by dragging them.

The headings in the spreadsheet come from the name of the controls.  Conditional formatting and VBA code work on both the spreadsheet and form view.

To some extent, you have two forms in one.  Where this gets powerful is when you are using single form.  You can be working with a single record in form view, switch to datasheet view to copy or compare to other records or select another record and then switch back to form view to work on it in detail.

In Access 2002+ you also have the pivot table view.  With the pivot table view, the functionality of your continuous form (the top view in your uploaded image) could be duplicated in about 3-5 minutes.  It can also do things the other views cannot.
daveslaterAuthor Commented:
I think I have confised the situation.
To make it simple - how do I make the form in the first picture. I can so no VB code to make this except.

    ' Find the record that matches the control.
    Me.RecordsetClone.FindFirst "[Uni Ref] = '" & Me![Combo213] & "'"
    Me.Bookmark = Me.RecordsetClone.Bookmark

>how do I make the form in the first picture.
I thought you have already created that form but I guess that is a form that you are wanting to copy the design.

Starting from scratch, use the form wizard. Press F11, select forms, new, form wizard and the table or query to use for the form.  Select the fields you want in the order you want them displayed, select tabular.  Choose a style, name your form and select modify the form's design.  This gives you a form with the general layout that needs massaging.

Now drag your mouse over all the controls to select them all.  Go to Format menu, align, align left.  With all the controls selected, press Alt-Enter to open the properties dialog, select the format tab, set the following:
Back style Normal
Back color 16777215 (white)
special effect flat
border order style solid
border width Hairline
With all the controls selected, move them all the way to the left.
Now select all the controls in the header.  Move them up to the top of the header.
Select all the controls in the detail section.  Move them up to the top of the detail section.
Drag the bottom of the header and the detail section up.
That should do it.  You can make asthetic changes from there.  If you plan on using this format again, you can save it as a style.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
daveslaterAuthor Commented:
as easy as that.

Your welcome.  Took a bit for us to get on the same page but we got there.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.