?
Solved

MS Access 2007 In Forms mode

Posted on 2008-11-04
23
Medium Priority
?
362 Views
Last Modified: 2013-11-28
Can you add a carriage return in forms mode while typing in a memo box or in datasheet view?
0
Comment
Question by:OpmanSupport
  • 9
  • 8
  • 6
23 Comments
 
LVL 75
ID: 22878223
Control + J

mx
0
 
LVL 61

Expert Comment

by:mbizup
ID: 22878374
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
 
LVL 75
ID: 22878413
<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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 61

Expert Comment

by:mbizup
ID: 22878632
<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
 

Author Comment

by:OpmanSupport
ID: 22878692
I dont have an "other" tab for the memo field
0
 
LVL 75
ID: 22878724
"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
 

Author Comment

by:OpmanSupport
ID: 22878920
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
 
LVL 61

Expert Comment

by:mbizup
ID: 22878954
You seem to be looking at the table's design.

This property is controlled through your *form's* design.
0
 
LVL 75
ID: 22878981
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
 
LVL 61

Expert Comment

by:mbizup
ID: 22879029
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
 

Author Comment

by:OpmanSupport
ID: 22879057
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
 
LVL 75
ID: 22879101
Yes ... but, seems that property is MISSING in A2007.  Check the remaining tabs for the property mbizup mentioned 'Enter Key Behavior' ...

mx
0
 

Author Comment

by:OpmanSupport
ID: 22879126
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
 
LVL 75
ID: 22879168
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
 
LVL 61

Expert Comment

by:mbizup
ID: 22879240
<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
 
LVL 75
ID: 22879275
" 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
 
LVL 61

Expert Comment

by:mbizup
ID: 22879385
< 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
 
LVL 61

Expert Comment

by:mbizup
ID: 22879403
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
 
LVL 75
ID: 22879423
<sigh>

mx
0
 

Author Comment

by:OpmanSupport
ID: 22879443
Does this help to possibly figure out whats going on? It doesnt look like I have a form?
Access.jpg
0
 
LVL 61

Accepted Solution

by:
mbizup earned 200 total points
ID: 22879547
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
 

Author Closing Comment

by:OpmanSupport
ID: 31513170
Thank you to all for your help. Sorry for my ignorance in Access. You have all been very helpful.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 22879642
<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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

755 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question