473,224 Members | 1,968 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

Best program for use with memo fields

Hello,

I'm trying to find a good program to use for editing memo fields in Access
2003. I'd love to use Notepad or Wordpad, but the only option I'm really
finding is a program called Total Access Memo.
All I'm looking to do is have a field for notes, and be able to add/edit the
text - and be able to use the return key to add more lines, etc.without
jumping to the next record. Can Access do this natively?

TIA,

Charles
Nov 5 '07 #1
4 4310
On Nov 4, 7:22 pm, "Charles" <replytothenewsgr...@online.comwrote:
Hello,

I'm trying to find a good program to use for editing memo fields in Access
2003. I'd love to use Notepad or Wordpad, but the only option I'm really
finding is a program called Total Access Memo.
All I'm looking to do is have a field for notes, and be able to add/edit the
text - and be able to use the return key to add more lines, etc.without
jumping to the next record. Can Access do this natively?
from Help:

TextBox.EnterKeyBehavior Property

You can use the EnterKeyBehavior property to specify what happens when
you press ENTER in a text box control in Form view or Datasheet
view . Read/write Boolean.expression.EnterKeyBehavior
expression A variable that represents a TextBox object.

Remarks

For example, you can use this property if you have a control bound to
a Memo field in a table to make entering multiple-line text easier.
If you don't set this property to New Line In Field, you must press
CTRL+ENTER to enter a new line in the text box.

You can also set the default for this property by setting a control's
DefaultControl property in Visual Basic.
Nov 5 '07 #2
Yes, you can set the return key for that field to add new lines instead of
going to the next field. It's a simple property to set.

Total Access Memo (which I'm currently using extensively) is rich textbox
editor, which allows you to enter formatted text (bold, italic, etc.) in
your field. You don't want to use Total Access Memo for your purposes, as it
will store formatting codes with your text. Just set the property for the
Enter key in that field, and you should be good to go.

Neil
"Charles" <re*****************@online.comwrote in message
news:13*************@corp.supernews.com...
Hello,

I'm trying to find a good program to use for editing memo fields in Access
2003. I'd love to use Notepad or Wordpad, but the only option I'm really
finding is a program called Total Access Memo.
All I'm looking to do is have a field for notes, and be able to add/edit
the
text - and be able to use the return key to add more lines, etc.without
jumping to the next record. Can Access do this natively?

TIA,

Charles


Nov 5 '07 #3
Lyle & Neil,

Thank you for the help - everything is working fine now. I can use the
return key to add paragraphs, etc without any problem. Xtra kudos for saving
me $$$$$.

Charles


"Charles" <re*****************@online.comwrote in message
news:13*************@corp.supernews.com...
Hello,

I'm trying to find a good program to use for editing memo fields in Access
2003. I'd love to use Notepad or Wordpad, but the only option I'm really
finding is a program called Total Access Memo.
All I'm looking to do is have a field for notes, and be able to add/edit
the
text - and be able to use the return key to add more lines, etc.without
jumping to the next record. Can Access do this natively?

TIA,

Charles


Nov 5 '07 #4
Believe me: if you had used a rich text editor to edit plain text memo
fields, the money you had spent would have been the least of your concerns!
;-)

"Chas" <reply-to-the-newsgroupwrote in message
news:13*************@corp.supernews.com...
Lyle & Neil,

Thank you for the help - everything is working fine now. I can use the
return key to add paragraphs, etc without any problem. Xtra kudos for
saving me $$$$$.

Charles


"Charles" <re*****************@online.comwrote in message
news:13*************@corp.supernews.com...
>Hello,

I'm trying to find a good program to use for editing memo fields in
Access
2003. I'd love to use Notepad or Wordpad, but the only option I'm really
finding is a program called Total Access Memo.
All I'm looking to do is have a field for notes, and be able to add/edit
the
text - and be able to use the return key to add more lines, etc.without
jumping to the next record. Can Access do this natively?

TIA,

Charles



Nov 5 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jeremy | last post by:
I have a pretty straightforward database that is designed to record free-form information about products (date, source and a memo field). This is searched and updated via a form. For new records,...
1
by: tHeRoBeRtMiTcHeLL | last post by:
What is the best practice for dealing with many input forms that contain memo fields to capture exceptions and extra information ( an audit trail or updates field would be one example) needed as...
2
by: jacoballen | last post by:
I have a query that combines the results of three related tables. The memo fields are truncated to 255 characters, but I need all the information in them. I'm aware that removing code such as...
7
by: maffonso | last post by:
Hi guys, My table has a memo field. At the end of the month a run a report and I would like to concatenate the memo fields in a unique field by dept. Im thinking doing this through totals button...
7
by: midlothian | last post by:
Does using CStr on a memo field truncate it to 255 characters? Seems like this is happening with some data in my tables. Is there a way around this?
9
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo...
10
by: ARC | last post by:
This is mainly a speed question. In this example: I have a QuotesHdr table that has a few memo fields. If these memo fields are used extensively by some users, and if their are a large number of...
2
by: steph | last post by:
I have a table with 250 fields. Of course you are wondering why 250 fields... what could I possibly be storing in so many fields? I am using this table as a general import table for files that...
4
by: Wayne | last post by:
I've been asked to construct a database which will require several memo fields. This database will be the standard frontend/backend mdb configuration. I have read many posts describing the...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.