Changing Data Type of Column in Query.

[Bird_e_boy]

Hi,

I have a table (Table 1) with three columns of the following type:

Example Table1:

Col1 - Text
Col2 - DateTime
Col3 - Memo

I have a query (Query1) that pulls information on those three columns in
Table1 and performs a function on Col3. The data within Col3 is greater than
255 which is the reason for choosing this data type for this column in
Table1. The function performed on Col3 removes carriage returns from the
data and replaces them with " ", it then returns this string (data returned
retains its original length). The problem is that Access converts the data
type of Col3 into a'Text' data type which has a maximum size of 255 therefore
truncating the data returned from the function. Is there any way to ensure
the column created in the query to recieve the results of the function is set
to memo instead of being set to 'TEXT'.

Example of Query1:

SELECT Col1, Col2, replaceVal(Col3)
FROM Table1

 

[John Spencer]

I don't see this behavior on my sample query.

Are you trying to use a maketable query and populate that with the results?

I am using Access 2003 SP1 for the testing.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County