Help with DataType! - Microsoft Access / VBA

Sam A Ruos

Is there any settings in Acces200, which I can set the Memo data type to
take more than 255 chars?
Thanks Anyone!
/Sam

Nov 13 '05 #1

Subscribe Post Reply

1278

Rick Brandt

"Sam A Ruos" <sa******@yahoo.com> wrote in message
news:_L*****************@newsb.telia.net...

Is there any settings in Acces200, which I can set the Memo data type to
take more than 255 chars?
Thanks Anyone!

Memo DataType already accepts more than 255 characters. It is the Text
DataType that is limited to 255.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #2

fredg

On Thu, 04 Nov 2004 16:27:38 GMT, Sam A Ruos wrote:

Is there any settings in Acces200, which I can set the Memo data type to
take more than 255 chars?
Thanks Anyone!
/Sam

Just to clarify this for you....
A Text datatype has a limit of 255 characters.
A Memo datatype can contain 65000+ characters.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 13 '05 #3

ColinWard

The Memo data type stores up to 65,536 characters by default. The text
data type can only store 255. If you are using a text field, and not a
memo data type as you stated, then simply change the field type to memo.

Colin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #4

Sam A Ruos

Thank you! You're right about "Memo". I altered the settings and it works
fine.
Thanks for your help!
/Sam

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:2u*************@uni-berlin.de...

"Sam A Ruos" <sa******@yahoo.com> wrote in message
news:_L*****************@newsb.telia.net...
Is there any settings in Acces200, which I can set the Memo data type to
take more than 255 chars?
Thanks Anyone!

Memo DataType already accepts more than 255 characters. It is the Text
DataType that is limited to 255.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #5

Sam A Ruos

Thank you! You're right about "Memo". I altered the settings and it works
fine.
Thanks for your help!
/Sam

"fredg" <fg******@example.invalid> wrote in message
news:2p*****************************@40tude.net...

On Thu, 04 Nov 2004 16:27:38 GMT, Sam A Ruos wrote:
Is there any settings in Acces200, which I can set the Memo data type to
take more than 255 chars?
Thanks Anyone!
/Sam

Just to clarify this for you....
A Text datatype has a limit of 255 characters.
A Memo datatype can contain 65000+ characters.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 13 '05 #6

Sam A Ruos

Thank you! You're right about "Memo". I altered the settings and it works
fine.
Thanks for your help!
/Sam
"ColinWard" <je*********@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

The Memo data type stores up to 65,536 characters by default. The text
data type can only store 255. If you are using a text field, and not a
memo data type as you stated, then simply change the field type to memo.

Colin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #7

Similar topics

Help with template find_if predicate

by: mikets | last post by:

Hi there, I found out that very often I use the following construct: for (it = myvec.begin(); it != myvec.end(); ++it) { if (it->name() == "myname") break; } Certainly, the container the...

C / C++

HELP! XSLTranform and XMLTextWriter Error

by: Amanda | last post by:

I have tried everything with this! I get an error stating "Index was outside the bounds of the array" My code looks like this.... xmlDoc = New XmlDocument() xmlDoc.Load("xml.doc") xslDoc...

.NET Framework

numeric conversion error need your help

by: al | last post by:

Dim dbParam_amount As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_amount.ParameterName = "@amount" dbParam_amount.Value = amount.text dbParam_amount.DbType =...

ASP.NET

Need Help deserializing Binary Field in C++

by: S Wheeler | last post by:

Hi All - I am creating a upgrade utility that transfers an bin / exe image over an xml stream. But I can not seem to get the deserialization of the binary field to work correctly. What I have is...

.NET Framework

Compound document (data & schema) help w/XSLT

by: Scott Zabolotzky | last post by:

I've got an XML file that contains both a data section and a custom schema section. The data may represent only a subset of the parameters defined by the schema. I'm new to XSLT and I'm trying...

.NET Framework

XSLT help

by: Scott Zabolotzky | last post by:

I have the following XML sample: <Component Name="A"> <Param Name="OptionEnabled" DataType="boolean"> <Default>true</Default> </Param> <Param Name="Size" DataType="unsignedInt"/> <Param...

.NET Framework

Template member function help.

by: Jason | last post by:

/* I have never use template before, so bear with me. Here is what I am trying to do: I declare an abstract base class MatrixInterface with template to define an interface for all my...

C / C++

Please help me spot the difference

by: Andreas Vinther | last post by:

I have a small piece of code that compiles but does not perform like I want it to. This code works: ---------------- void *y0; void *y1; void *y2; void *y3;

C / C++

A little help using some functions for a Heap

by: wishbone34 | last post by:

Hi, I have a question regarding the use of a couple functions I have for an assignment.. first here is the header file that im trying to use...

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

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$) { } ...

Javascript

Batch import of multiple excel files into the database

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

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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

C / C++

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

General

Changing the language in Windows 10

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

Windows Server

Problem With Comparison Operator <=> in G++

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

C / C++

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

Online Marketing