Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sizing Controls on Subform Datasheet View

Sizing Controls on Subform Datasheet View

Sizing Controls on Subform Datasheet View

I created a form to be used as a subform and sized the controls to appear the way I want them.

When I change the view to datasheet view the sizing defaults to a column width not of my choosing.

Is there a way to control how controls appear in datasheet view or am I stuck with what Access decides the widths should be?

Larry De Laruelle

Replies continue below

Recommended for you

RE: Sizing Controls on Subform Datasheet View

Larry, I have the same feelings about the datasheet view. Try using the continuous forms view for your subform. There are advantages to this, first the user cannot resize the columns, you can control movement in the subform, you can attach code to display the current row with a highlight color. If you are interested, I have an example db that I can send you showing some of these things.

John A. Gilman

RE: Sizing Controls on Subform Datasheet View

Thanks John.

Gives a little different look than I really wanted, but sometimes you have to live with what works.

Larry De Laruelle

RE: Sizing Controls on Subform Datasheet View

If you play around a little with the form design you will find it hard to tell it is not a datasheet. Even the ability to move up and down by using the arrow keys can be applied to the continuous form view.

John A. Gilman

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close