We have a person that has 4 columns and 20 rows of data.

when they have all the info they want to put in the data a row at a time.
BUT if they only have the first column of data they want to enter that.

with tab orders you can set it to go across or down each column.

He wanted to know if he could use the down arrow to put in the one column.

has anyone ever faced this or heard about someone wanting this, and how you
might go about doing it?

I am not sure what if anything can be done this way

thanks big time for any hints ideas or whatever

Jerry

sparks (AT) somewhere (DOT) net wrote:

Use a datasheet view for the form. What can be made to look nice is a
form view main form with a datasheet subform. Then you can arrow to
your heart's content.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Is this an Access or Excel question? If Access, is the user entering data
directly into the tables? If so, they shouldn't be. By moving down, do you
mean going from one record to the next? If so, try the Page Down key on a
form. The Down Arrow will move to the next record in a table. On a form, the
Down Arrow will move to the next field or next character, depending on the
selection in the Keyboard tab in Tools|Options.

--
Wayne Morgan
MS Access MVP


<sparks (AT) somewhere (DOT) net> wrote

On Fri, 07 Jan 2005 15:23:48 GMT, "Wayne Morgan"
<comprev_gothroughthenewsgroup (AT) hotmail (DOT) com> wrote:


was a little sleepy when I posted this.

its on a std form. we have 64 fields... 16 down and 4 across

the data is based on what is in col 1 and the data is entered in the next 3
fields going across

1 2 3 4
--- ---- ---- ----
---- ---- ---- ----
---- ---- ---- ----
---- ---- ---- ----
---- ---- ---- ----
---- ---- ---- ----
---- ---- ---- ----

something like this (hope it keeps format on post)
they want to enter something in col 1 then the 3 followups in cols 2-4
going across

but if they only have the initial data they want to be able to go down col 1
entering it only.

so its fill up everything going 1 2 3 4
or just col 1 1 1 1 1 1 1 1 1

does this make more since

and sorry for the terrable description

jerry

sparks (AT) somewhere (DOT) net wrote:

D-A-T-A-S-H-E-E-T V-I-E-W !!!!!!!!!!!!!

8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Yes, it makes more sense. I think you'll find the Page Down key will do what
you want as long as there is no code in the form's Current event to move the
cursor to a particular control with every record change.

--
Wayne Morgan
MS Access MVP


<sparks (AT) somewhere (DOT) net> wrote