473,703 Members | 2,643 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4340
On Nov 4, 7:22 pm, "Charles" <replytothenews gr...@online.co mwrote:
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.EnterKe yBehavior Property

You can use the EnterKeyBehavio r property to specify what happens when
you press ENTER in a text box control in Form view or Datasheet
view . Read/write Boolean.express ion.EnterKeyBeh avior
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.co mwrote in message
news:13******** *****@corp.supe rnews.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.co mwrote in message
news:13******** *****@corp.supe rnews.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.supe rnews.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.co mwrote in message
news:13******** *****@corp.supe rnews.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
4719
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, the memo field is usually filled by cutting and pasting from e-mails, web content and spreadsheets. The only problem is that some of the memos can be just a few words, and some can be tens or hundreds of lines, and I've realised that zooming...
1
2200
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 an item moves through different processes. Note, there are some tables in which I have simply added a text field set to 255, however, some of these tables will have many edits and updates.
2
3590
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 DISTINCT and GROUPBY will fix this problem (as discussed in other threads in this group), but I need to limit the query results to unique values, which is what DISTINCT does for me. Any suggestions? Thanks, Jacob
7
2688
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 , but in the combobox there are only max,min,sum,.. There is no concatenate function. Im avoinding doing that using VBA. Somebody help me please.
7
7918
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
5733
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 field is printed within the detailed area. The problem is, the apllication is not setup properly, thus the users are entering data within the memo field as: location1 1/1/2005 1/1/2006
10
3053
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 records in QuotesHdr, should I break out the memo fields into a separate table? The thinking here is that, for Quotes selection dropdowns that display all entries in QuotesHdr for selection, I would think that the entire record comes down over...
2
4767
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 vary based on user selections. The input files are CSVs and can number from 2 to 175 columns. Each field is usually able to fit into a Text field (< 255 characters) but every now and then a longer field creeps in. since I don't know in which column...
4
5665
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 corruption problems associated with memo fields, especially in a networked environment. Am I asking for trouble if I go ahead with this project?
0
8749
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8662
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9243
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9002
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7853
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4420
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2434
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2057
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.