extending memo field length - Microsoft Access / VBA

Chris

I'm sure this is a very easy one if you know, but any help would be
appreciated
I have a field in my database which needs to be as long as poosible.
in the help it says that a memo field is 4000 odd characters long,
which would be about right. However my memo field does not remember
any more than about 300 characters. Is there a box or something to tick
to allow longer field lengths?
thanks again

Nov 13 '05 #1

Subscribe Reply

7526

Allen Browne

Memo and its interface can easily handle 64000 characters.

If yours is truncating after 255 characters:
1. Open the table in design view.

2. Double-check the field is a Memo (not Text) type.

3. Make sure you do not have anything in the Format property of the field
(lower pane in Table Design view).

4. Open your form in design view.

5. Right-click the text box bound to the memo, and choose Properties. Make
sure there is nothing in the Format or Input Mask properties of the text
box.

6. If the form is based on a query, make sure there is no aggregation in the
query. For example, it must not have a DISTINCT predicate, or a GROUP BY
clause on the memo.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Chris" <sc***********@ hotmail.com> wrote in message
news:32******** *************** ***@posting.goo gle.com...

I'm sure this is a very easy one if you know, but any help would be
appreciated
I have a field in my database which needs to be as long as poosible.
in the help it says that a memo field is 4000 odd characters long,
which would be about right. However my memo field does not remember
any more than about 300 characters. Is there a box or something to tick
to allow longer field lengths?
thanks again

Nov 13 '05 #2

Chris

thanks very much - worked great. Turns out i left an > in the format
field to make it uppercase. My database is all finished now!

Nov 13 '05 #3

Similar topics

5809

ACCESS memo fields in ASP

by: Hugh Welford | last post by:

Hi ... using WIN XP/ FP 2000/ IIS. I need to be able to retieve variable length (>255 characters) messages which have been saved in a memo field in an access data base on the server. I am using the following code to test this : - <% set objconn = server.createobject ("ADODB.connection") set objrec = server.createobject ("ADODB.recordset") objconn.open "DSN=daters"

ASP / Active Server Pages

7130

OleDbDataReader and MS Access Memo Field

by: Rich | last post by:

Ok I am trying to read a memo field from an Access DB that has more than 255 char. I am only getting 255 chars back from the reader. Why is this and how do i get the whole memo field. Here is a piece of the code I am using Do While m_oleDBReader.Read() var = m_oleDBReader("memo_field") Loop

.NET Framework

2510

Checking for Text & Moving to the end of a Memo Field

by: PMB | last post by:

Thank you in advance for any and all assistance. I'm trying to input data from strings to a memo field. I would like to know how to check first to see if there is text there currently and if so move to the end and input the new text. Also, would like to know if I can change the justification on each line of text as it's entered. i.e. Company Name, address, city state and zip would be centered and all the

Microsoft Access / VBA

8215

Truncated memo fields when using SELECT DISTINCT

by: skinnybloke | last post by:

Hi - I have a problem with a memo field being truncated to about 255 characters when running a Access 2002 query. This only seems to happen if I use SELECT DISTINCT. It works ok using SELECT by itself. does anyone know why this happens and how to stop it?

Microsoft Access / VBA

2126

Wierd error when editing an Access Memo field.

by: VRWC | last post by:

Hi folks, Hope someone has some insight to this problem. I have a form that contains a large (5" x 4") text box bound to a memo field. This field allows users to type in the text of an email to be sent through Outlook (via automation). I ONE user who send me his back end data base where he has inserted several two - three page emails. When scrolling through the records, two of about twenty records shows and error that says "Too...

Microsoft Access / VBA

1647

Help with setting Access Memo field restrictions using DDL

by: Scott Van | last post by:

Hello- I am trying to create an Access table using DDL that has a memo field. I have the syntax to create the memo field but I can't find the syntax to also set whether the memo field should allow zero length. I can set this option using the Access interface directly, but I want to create this table and this column definition using a DDL script. Listed below is the script that works but I just need the syntax to set the additional...

Microsoft Access / VBA

5740

parse or format data from memo field onto Access report

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

Microsoft Access / VBA

4524

Auto Extending Verticle Lines

by: colemanj4 | last post by:

Hello, In Report Design View in the Detail Section I have several vertical lines that I would like to autoextend with the length of the detail section. This is becasue I have a memo field that "Can Grow" so that it can fit all the information that the users input. If anyone knows how to do this for the lines that would be greatly appreciated. Thanks,

Microsoft Access / VBA

4770

Memo fields clobbered (Access 2003)

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...

Microsoft Access / VBA

9665

What is ONU?

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...

General

10199

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10139

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

9983

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9020

AI Job Threat for Devs

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...

Career Advice

5417

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5551

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4092

transfer the data from one system to another through ip address

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

C# / C Sharp

2909

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General