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?
 
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.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Control + J

mx
0
 
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"
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

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

mx
0
 
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?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
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.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
" 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
0
 
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.

0
 
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.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
<sigh>

mx
0
 
OpmanSupportAuthor Commented:
Does this help to possibly figure out whats going on? It doesnt look like I have a form?
Access.jpg
0
 
OpmanSupportAuthor Commented:
Thank you to all for your help. Sorry for my ignorance in Access. You have all been very helpful.
0
 
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.   :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.