Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Sub form layout (Acess 2000)

    I have a subform layed out in datasheet view with fields going across in the order A, B, C, D.
    However, when I drag the subform onto a form and display the form, the fields appear in a different order, say C, D, A, B.
    What must I do to get the fields in the proper order when the subform is embedded in another form?

  2. #2
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sub form layout (Acess 2000)

    Did you try rearranging them in Form view then saving the form? I have had lots of grief trying to rearrange fields in subforms and I have had pretty reliable success using this method. It certainly is not very techincal, but it has worked for me in the past I have had a similar problem.

    Carla

  3. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sub form layout (Acess 2000)

    I figured it out after fussing for a while. The key is to highlight the field by clicking in the column title area and then dragging the column to the position you want.

  4. #4
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sub form layout (Acess 2000)

    Hi Chuck,

    You've got it. Seems like there should be a better way, but I don't know what it would be. I have tried rearranging fields in design view and all sorts of things, and this is the only way I have been successful.

    Carla

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sub form layout (Acess 2000)

    This is one of the reasons why I avoid datasheet forms/subforms. Instead, I use continuous forms that look like datasheets. You can control in design view what they will look like in form view. With a datasheet, that is not psosible, as you and Chuck have found out.

  6. #6
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sub form layout (Acess 2000)

    Hans,

    A continuous form is a much better solution. I can't say I have ever tried this in the alternative to a subform, but I gave it a try this afternoon and it is so much easier to work with. I have done the same thing as Chuck fussing around until I could get it to do what I wanted. This is going to be so much better.

    Carla

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •