| |
You are here: Experts > Computing/Technology > Business Software > Using MS Access > Columns in MS Access Form
Expert: Scottgem - 11/6/2009
Question
QUESTION: I have an assignment for my computer science class - we created a database in Access, and we have to create a form for it as well.
The form is supposed to be formatted in a certain way, and have three different fields beside each other.
However, I can't seem to figure out how to do this, as access will only let me put two different fields beside each other, and I can't drag the other ones outside of the pre-determined "columns" that it created for me when I created the form.
Can you tell me how to get three fields beside each other, instead of two?
Thanks
ANSWER: What version of Access are you working in?
Also, you don't put "fields" on a form. You place controls that may or may not be bound to a field in a table. This is a subtle but important distinction.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: I'm using Access 2007.
If this helps, here is my assignment :
http://i38.tinypic.com/2nh2e0w.png
What I can't seem to do is get the "Date Joined Member Name Account Balance" all beside each other;
I can only do "Date Joined Member Name" and I can't seem to get Account Balance to go beside Member Name.
Answer
I suspected you are using 2007. You have two choices here. 1) Redo the form using the Form wizard (under More forms in the Create tab) or 2) in Design view of the form, go to the Arrange tab and under the control Layout section select to Remove.
Access 2007, by default, creates a stacked set of controls on a new form. Until you remove the stack, you can't move around controls as you want. If your instructor didn't explain this to you when discussing designing forms, they were remiss.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
Add to this Answer Ask a Question
|
|
