Need Large DataType in Module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a module that loops through a number of records and adds a text field
of each record together. This uses more than the alloted lenght of a String
field.

Is there a datatype that is longer than String in a module. Can't use Memo
in a module.
 
I was under a string can be millions of characters long..

I have no idea why you would need such a large string? What on earth do you
plan to do with this string?

Any reason you can't write out the data to text file as you process the
records?

You might want to explain/expand on what you are tying to do, but something
seems not right....

How long is this string to be? what do you plan to do with it?
 
I have a table [Status Updates] which allows updates on "Meeting Actions".
The data collected is the date and text of what that update is, hence the
text field is large.

I am extracting to an excel file a list of all the "Meeting Details", one
per line and as part of that I have a cell to contain all the [Status
Updates], hence this cell can take alot of data.

The size of a string datatype is 255 in Access, hence I really need to use a
memo datatype however Modules don't accept this datatype.

Don't fancy writing out to a file, as I could have any number of Meeting rows.
 
hi Dennis,

i assume at least.

Re: Need Large DataType in Module said:
The size of a string datatype is 255 in Access, hence I really need to use a
memo datatype however Modules don't accept this datatype.
Click to expand...
You have to distinguish between field types in tables and data types in
VBA:

The text (string) field type has a length limitation of 255 characters.

The VBA string data type has not this limitation, it can hold about 2^31
characters (depends on your system memory).

mfG
--> stefan <--
 
I have just checked the query and you are correct, the query that calls the
module does indeed return all the field, however when it get's into Excel vie
TransferSpreadsheet it's cut short at 255.
 
hi,

come on, get your name in to From: line.

Re: Need Large DataType in Module said:
I have just checked the query and you are correct, the query that calls the
module does indeed return all the field, however when it get's into Excel vie
TransferSpreadsheet it's cut short at 255.
Click to expand...
Of course it's cut. You are using a query or table as record source for
TransferSpreadsheet. Hence the field limitation of 255 characters.

You have to use Excel automation to get your complete data into Excel.


mfG
--> stefan <--
 
How do I use Excel automation?

Stefan Hoffmann said:
hi,

come on, get your name in to From: line.


Of course it's cut. You are using a query or table as record source for
TransferSpreadsheet. Hence the field limitation of 255 characters.

You have to use Excel automation to get your complete data into Excel.


mfG
--> stefan <--
Click to expand...
 
Back
Top