Tim-
Those options don't matter. The Behavior Entering Field setting in Options simply controls what happens to the cursor when the user tabs or clicks into the field. Depending on your environment, users can set these to their liking. I personally use Go To End of Field.
The property that matters is the Enter Key Behavior property of the text box control on your form. That should be set to New Line in Field.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of timdbui@gmail.com
Sent: Friday, November 22, 2013 10:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: RE: RE: [MS_AccessPros] Controlling the format of a memo field
Hi Bill and John,
So it is not the Plain Text or Rich Text issue that I thought. I went into Options, Client Settings and saw "Behavior entering field" selected as "Select entire field." Should I check off one of the other two, "Go to start of field" or "Go to end of field"?
Thanks to both of you!
Tim
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote:
Duh.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of wrmosca@...
Sent: Friday, November 22, 2013 9:46 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: RE: [MS_AccessPros] Controlling the format of a memo field
It could be that Tim's original text box did not have the Enter Key Behavior property set to New line.
Bill
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote:
Tim-
I tried Shift-Enter in a Rich Text field in the Northwind sample in 2007, and it worked just fine.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of timdbui@...
Sent: Friday, November 22, 2013 7:57 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: [MS_AccessPros] Controlling the format of a memo field
Thanks for your advice, John!
I tried Shift Enter but it didn't work in the beginning. I then changed the format from Rich Text to Plain Text, and it worked in Plain Text. Should changing from Rich Text to Plain make a difference? It works now in Plain Text, but I don't understand why.
Thanks again for your help!
Tim
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote:
Tim-
Hold down the Shift key and press the Enter key when you finish typing a line.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of timdbui@...
Sent: Friday, November 22, 2013 4:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Controlling the format of a memo field
Hi, would any of you please advise if if this is possible in a memo field?
I created a memo field on a form to record notes. The notes have several items as:
1. xxxx
2.yyyy
3.zzzz
However, in my report for print out, all of the 1,2,and 3 are concatenated and become:
1. xxxx2.yyyy3.zzzz
Is there a way to keep the 1,2, and 3 separated as different lines?
Thanks so much!
Tim
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar