MS Access 2007 In Forms mode

Can you add a carriage return in forms mode while typing in a memo box or in datasheet view?
OpmanSupportAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Control + J

mx
mbizupCommented:
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"
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
<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>
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

mbizupCommented:
<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>
OpmanSupportAuthor Commented:
I dont have an "other" tab for the memo field
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"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
OpmanSupportAuthor Commented:
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
mbizupCommented:
You seem to be looking at the table's design.

This property is controlled through your *form's* design.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
mbizupCommented:
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.
OpmanSupportAuthor Commented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Yes ... but, seems that property is MISSING in A2007.  Check the remaining tabs for the property mbizup mentioned 'Enter Key Behavior' ...

mx
OpmanSupportAuthor Commented:
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?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
mbizupCommented:
<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.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
" 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
mbizupCommented:
< 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.

mbizupCommented:
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.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
<sigh>

mx
OpmanSupportAuthor Commented:
Does this help to possibly figure out whats going on? It doesnt look like I have a form?
Access.jpg
mbizupCommented:
OpmanSupport,

It doesn't look like you have a form created for this at this time.

The easiest way to do this in A2K7 is:

- In the Navigation Panel, select your table.
- Click the "Create" tab on the ribbon
- Click on "Form"

This will create a form, bound to your table, with controls bound to all of the fields.

At that point you should be able to select the textbox in question and set it's Enter Key Behavior property.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
OpmanSupportAuthor Commented:
Thank you to all for your help. Sorry for my ignorance in Access. You have all been very helpful.
mbizupCommented:
<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.   :-)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.