Need Carriage Return after Data Entry

[alecgreen]

Hi

I have a very basic form, linked to a table called tblJobs. I am using
the form for data entry in to tblJobs and want to add a carriage
return after data is enteredm so that the cursor is in place for the
next data entry. Can anyone help please.

Thanks

Alec

 

[John W. Vinson]

Hi

I have a very basic form, linked to a table called tblJobs. I am using
the form for data entry in to tblJobs and want to add a carriage
return after data is enteredm so that the cursor is in place for the
next data entry. Can anyone help please.

Thanks

Alec

Access tables are not text files, and a "record" does not end with a carriage
return. A Continuous Form can be (and by default, will be) set up so that
after entering data into all of the controls bound to fields in tblJobs,
you'll find yourself in the first field of the blank "new record", ready to
add new data. Is this not what you're seeing? What is the "Default View"
property of the form? What is its "Cycle" property (in this case you want the
default All Records, not the Current record which will keep you on the same
record).
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com