MS Access 2007 In Forms mode

Control + J

mx

OpmanSupport,

In addition to mx's suggestion:

Ctrl + Enter

Or for a lasting solution - In the control's property sheet, under the "Other" tab, set the Enter Key Behavior property to "New Line In Field"

<0t>
Miriam .. the 'EEple'  function is not working right - what you see above is *not* what I selected and what currently shows in my profile!</ot>

<ot>
Joe,
Your's looks like the default. Give it another try.  Mine seems to be behaving itself.  If it doesn't work out, give it a few days - I beleive these things are a work in progress.  If you continue to have problems with it, post a thread in EE Bugs.  Drop me a note offline if you need the link.

 </ot>

I dont have an "other" tab for the memo field

"I dont have an "other" tab for the memo field"

It's on the Property Sheet for the Text box that you have that field as the Control Source.

mx

It's on the Property Sheet for the Text box that you have that field as the Control Source.

Attached is what I am seeing
Access.jpg

You seem to be looking at the table's design.

This property is controlled through your *form's* design.

You need to do this on the Form, not in Table design.

Your JPG is an image of a Table property sheet.

You said you wanted to do this on a Form ... ?

mx

If you are entering data directly into your table, you would have to use Ctrl+J as mx suggested or Ctrl+Enter.

That said, it is not advisable to allow users to enter data directly into a table.  You should always use a form as a user interface.  

Just clarifying, the Enter Key Behavior property is in:
- The Form's design view
- In the specific control's property sheet
- under the "Other" tab.

You seem to be looking at the table's design.

This property is controlled through your *form's* design.

Is this the right place? See attached file again please.
Access.jpg

Yes ... but, seems that property is MISSING in A2007.  Check the remaining tabs for the property mbizup mentioned 'Enter Key Behavior' ...

mx

Yes ... but, seems that property is MISSING in A2007.  Check the remaining tabs for the property mbizup mentioned 'Enter Key Behavior' ...

mx

Checked them all to no avail. I used to do some hacking in Access and remember that, but I dont see it here. The only thing I see is "On Enter" and I dont know the expression to use for go to next line. Any suggestions?

Well, it must be on one of the tabs (not the Events tab) - maybe the Format tab - for that control.  Maybe the name has changed ?  I don't have A2007 loaded now.

mx

<seems that property is MISSING in A2007>

'tis not :-)

I'm looking right at it in my own Access 2K7 database.

I'm not sure why it is not showing up in the property sheet in the jpg.

Can you post a sample of the database using the "Attach File" feature?

If your database is store in .accdb format you may need to rename it to .txt

Joe,
 would you be able to take a look at it in A2K7?

I won't be able to until later this evening.

" would you be able to take a look at it in A2K7?"
Sorry, I don't have a system with A2007

Maybe it's because the form is in 'datasheet' mode ??

mx

< Maybe it's because the form is in 'datasheet' mode ??>

Hmmm... just checked that and that doesn't seem to have an effect.  The property should appear right under the "Datasheet Caption" property.

Aha!

I just noticed, at the top of the .jpg, "Report Header"!

This needs to be a *form* - not a report or a table.

AFAIK, you cannot enter data into a report.

<sigh>

mx

Does this help to possibly figure out whats going on? It doesnt look like I have a form?
Access.jpg

Thank you to all for your help. Sorry for my ignorance in Access. You have all been very helpful.

<Thank you to all for your help. Sorry for my ignorance in Access. You have all been very helpful.>


Glad to help out.  We all start somewhere.   :-)