Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Moving fields in table design using keyboard

Discussion in 'Information Technology' started by Callista, Jul 28, 2006.

  1. Callista

    Callista
    Expand Collapse
    Guest

    Any ideas for moving a field in table design view without the mouse to click
    and drag? Everything I have tried has resulted in the data in that field
    being lost. Using Cut doesn't seem to keep it on the clipboard ready to
    paste, cut equates to delete.
    Help, please!
     
  2. Loading...

    Similar Threads Forum Date
    Islam Moving Mountains Interfaith Dialogues Nov 29, 2012
    World Man punches nurse for removing wife's burqa Breaking News Dec 25, 2011
    SALDEF Stop Arizona From Removing Balbir Singh Sodhi from 9/11 Memorial Sikh Organisations Apr 27, 2011
    Moving Forward, Or Sliding Backward Sikh Sikhi Sikhism Oct 20, 2010
    Moving to Montreal, Canada Need Help! Community Out-Reach Oct 18, 2010

  3. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    Once the control has been selected, you can move it using the arrow keys. It
    will move one grid segment at a time. The size of the grid is the dots in
    the background of the form in design view. To "nudge" the control, hold down
    the Ctrl key as you press the arrow keys. To resize the control, hold down
    the shift key as you press the arrow keys.

    --
    Wayne Morgan
    MS Access MVP


    "Callista" <callista@no_spam.surejob.co.uk> wrote in message
    news:uKXP2YEmGHA.3352@TK2MSFTNGP02.phx.gbl...
    > Any ideas for moving a field in table design view without the mouse to
    > click and drag? Everything I have tried has resulted in the data in that
    > field being lost. Using Cut doesn't seem to keep it on the clipboard ready
    > to paste, cut equates to delete.
    > Help, please!
    >
     
  4. Callista

    Callista
    Expand Collapse
    Guest

    Thanks for the interest in my problem,Wayne. I can move controls in design
    view for forms and reports but I wanted to be able to reorder the fields in
    Tables in the design view and that is rather different as you know. Any
    further ideas?
    BTW your mention of the resizing is helpful for working with forms and
    reports.
    Thanks
    "Wayne Morgan" <comprev_gothroughthenewsgroup@hotmail.com> wrote in message
    news:eghTXfEmGHA.4808@TK2MSFTNGP05.phx.gbl...
    > Once the control has been selected, you can move it using the arrow keys.
    > It will move one grid segment at a time. The size of the grid is the dots
    > in the background of the form in design view. To "nudge" the control, hold
    > down the Ctrl key as you press the arrow keys. To resize the control, hold
    > down the shift key as you press the arrow keys.
    >
    > --
    > Wayne Morgan
    > MS Access MVP
    >
    >
    > "Callista" <callista@no_spam.surejob.co.uk> wrote in message
    > news:uKXP2YEmGHA.3352@TK2MSFTNGP02.phx.gbl...
    >> Any ideas for moving a field in table design view without the mouse to
    >> click and drag? Everything I have tried has resulted in the data in that
    >> field being lost. Using Cut doesn't seem to keep it on the clipboard
    >> ready to paste, cut equates to delete.
    >> Help, please!
    >>

    >
    >
     
  5. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    The following works, but it doesn't just "move" the field and is probably
    more trouble than its worth.

    The only way I see to do it using the keyboard in a table is to select the
    field using the mouse. Next, press the submenu key on the keyboard, select
    Cut, go to where you want to place the field and select the field below
    where you want to place the field your moving, press the submenu key again
    and choose Insert Rows, then select the new row, press the submenu key, and
    choose Paste.

    When you Cut you will get a message asking if you want to permanently delete
    the row, tell it Yes. The problem is, while this will move the field, I
    suspect it will delete all of the data in that field since you're really
    creating a new field with the same properties. This would be fine for an
    empty table. Also, you won't be able to do this with the Primary Key field
    or any other field involved in a relationship with other tables.

    --
    Wayne Morgan
    MS Access MVP


    "Callista" <callista@no_spam.surejob.co.uk> wrote in message
    news:%23pPkTtEmGHA.3732@TK2MSFTNGP05.phx.gbl...
    > Thanks for the interest in my problem,Wayne. I can move controls in design
    > view for forms and reports but I wanted to be able to reorder the fields
    > in Tables in the design view and that is rather different as you know.
    > Any further ideas?
    > BTW your mention of the resizing is helpful for working with forms and
    > reports.
    > Thanks
    > "Wayne Morgan" <comprev_gothroughthenewsgroup@hotmail.com> wrote in
    > message news:eghTXfEmGHA.4808@TK2MSFTNGP05.phx.gbl...
    >> Once the control has been selected, you can move it using the arrow keys.
    >> It will move one grid segment at a time. The size of the grid is the dots
    >> in the background of the form in design view. To "nudge" the control,
    >> hold down the Ctrl key as you press the arrow keys. To resize the
    >> control, hold down the shift key as you press the arrow keys.
    >>
    >> --
    >> Wayne Morgan
    >> MS Access MVP
    >>
    >>
    >> "Callista" <callista@no_spam.surejob.co.uk> wrote in message
    >> news:uKXP2YEmGHA.3352@TK2MSFTNGP02.phx.gbl...
    >>> Any ideas for moving a field in table design view without the mouse to
    >>> click and drag? Everything I have tried has resulted in the data in that
    >>> field being lost. Using Cut doesn't seem to keep it on the clipboard
    >>> ready to paste, cut equates to delete.
    >>> Help, please!
    >>>

    >>
    >>

    >
    >
     

Share This Page