473,378 Members | 1,422 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,378 software developers and data experts.

Memo fields in reports

Is there a limit to the number of memo fields that can be put in a report?
Mar 26 '12 #1

✓ answered by TheSmileyCoder

A memo field is limited to showing the first 64.000 charecters stored in said memo field. However you can store up to the 2gb storage limit in a single memo field.

That is really the only limitation I am currently aware of.

2 1414
NeoPa
32,556 Expert Mod 16PB
Not as far as I'm aware. Why do you ask?
Mar 27 '12 #2
TheSmileyCoder
2,322 Expert Mod 2GB
A memo field is limited to showing the first 64.000 charecters stored in said memo field. However you can store up to the 2gb storage limit in a single memo field.

That is really the only limitation I am currently aware of.
Mar 28 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: jimmyshaw83 | last post by:
I am sorry if this topic is tired, but after all that I have read I am still in the woods here. I have built a database to handle weekly and monthly reports of what people are doing. They submit...
13
by: ken | last post by:
I have 5 memo fields in one of my tables. I need to add 7 more. Will this be a problem? Am I being paranoid? Thanks
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...
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...
7
by: munkee | last post by:
Hi all, I have 3 memo fields on my main table. I understand that they are susceptible to corruption over network environments. I am looking to move these memo fields in to seperate tables and I...
8
by: Jimmy Jones | last post by:
First of all - all answers that I could find via Google do not give me any explicit info as to how to handle this problem. So please - do not paste the following link for the hundreth time: ...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.