473,396 Members | 2,090 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,396 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 4318
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.