Hello,
I am wondering if there is a way to have the enter key move you down to the
next cell in the column, as opposed to over to the next cell in the row.

Thanks.

This newsgroup supports Microsoft Access.

It sounds like you're working in a spreadsheet. Try one of those
newsgroups...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Amanda" <(E-Mail Removed)> wrote in message
news:1DD4AEF8-B70D-484C-B2F8-(E-Mail Removed)...
> Hello,
> I am wondering if there is a way to have the enter key move you down to
> the
> next cell in the column, as opposed to over to the next cell in the row.
>
> Thanks.

I am working in a table in Access.

"Jeff Boyce" wrote:

> This newsgroup supports Microsoft Access.
>
> It sounds like you're working in a spreadsheet. Try one of those
> newsgroups...
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Amanda" <(E-Mail Removed)> wrote in message
> news:1DD4AEF8-B70D-484C-B2F8-(E-Mail Removed)...
> > Hello,
> > I am wondering if there is a way to have the enter key move you down to
> > the
> > next cell in the column, as opposed to over to the next cell in the row.
> >
> > Thanks.
>
>
>

Go to Tools > Options > Keyboard > "Move After Enter" and select "Next
Record". However, if you are using forms for other users, this can create
two problems - the user might not want to go to the next record, and you
might have a default key on the form which would be activated by the <enter>.
--
Gordon Jones


"Amanda" wrote:

> Hello,
> I am wondering if there is a way to have the enter key move you down to the
> next cell in the column, as opposed to over to the next cell in the row.
>
> Thanks.

Amanda

Access tables may look like spreadsheets but they aren't. Access tables
store data, but they don't work as well as Access forms for data entry.

You've described "how" you are trying to do something, but not "what". If
you'll describe a bit more specifically what being able to do what you
posted will allow you/your users to do, the folks here in the groups may be
able to offer a more functional alternative.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Amanda" <(E-Mail Removed)> wrote in message
news:90E1FCBD-755D-45E1-9437-(E-Mail Removed)...
>I am working in a table in Access.
>
> "Jeff Boyce" wrote:
>
>> This newsgroup supports Microsoft Access.
>>
>> It sounds like you're working in a spreadsheet. Try one of those
>> newsgroups...
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Amanda" <(E-Mail Removed)> wrote in message
>> news:1DD4AEF8-B70D-484C-B2F8-(E-Mail Removed)...
>> > Hello,
>> > I am wondering if there is a way to have the enter key move you down to
>> > the
>> > next cell in the column, as opposed to over to the next cell in the
>> > row.
>> >
>> > Thanks.
>>
>>
>>

Gordon, that worked perfectly. Thank you.

"Gordon Jones" wrote:

> Go to Tools > Options > Keyboard > "Move After Enter" and select "Next
> Record". However, if you are using forms for other users, this can create
> two problems - the user might not want to go to the next record, and you
> might have a default key on the form which would be activated by the <enter>.
> --
> Gordon Jones
>
>
> "Amanda" wrote:
>
> > Hello,
> > I am wondering if there is a way to have the enter key move you down to the
> > next cell in the column, as opposed to over to the next cell in the row.
> >
> > Thanks.