|
 |
access thread: Query question
Message #1 by "Leo Scott" <leoscott@c...> on Thu, 19 Dec 2002 08:23:21 -0800
|
|
I have a Table with 5 memo fields. I have built a query on this table (and
other linked tables) that returns these memo fields. This query is the
DataSource for a form. It appears that the query is only returning the
first 256 characters from the memo field and therefore the form is not
displaying all the information. Is there a way to get the query to return
all the data in the memo field?
Message #2 by "Thomas, Charles" <CThomas@D...> on Thu, 19 Dec 2002 17:12:02 -0500
|
|
How are you displaying the memo date information on your form i.e. textbox,
combo box, list box?
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Thursday, December 19, 2002 11:23 AM
To: Access
Subject: [access] Query question
I have a Table with 5 memo fields. I have built a query on this table (and
other linked tables) that returns these memo fields. This query is the
DataSource for a form. It appears that the query is only returning the
first 256 characters from the memo field and therefore the form is not
displaying all the information. Is there a way to get the query to return
all the data in the memo field?
Message #3 by "Leo Scott" <leoscott@c...> on Fri, 20 Dec 2002 08:26:17 -0800
|
|
The memo field is displayed in a textbox with a vertical scrollbar and no
horizontal scrollbar. However, it is based on a persisted query in the
queries tab. When I open that query the data is truncated at 256 characters
also.
|-----Original Message-----
|From: Thomas, Charles [mailto:CThomas@D...]
|Sent: Thursday, December 19, 2002 2:12 PM
|To: Access
|Subject: [access] RE: Query question
|
|
|How are you displaying the memo date information on your form i.e. textbox,
|combo box, list box?
|
| -----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Thursday, December 19, 2002 11:23 AM
|To: Access
|Subject: [access] Query question
|
|I have a Table with 5 memo fields. I have built a query on this table (and
|other linked tables) that returns these memo fields. This query is the
|DataSource for a form. It appears that the query is only returning the
|first 256 characters from the memo field and therefore the form is not
|displaying all the information. Is there a way to get the query to return
|all the data in the memo field?
|
|
|
|
|
|
|
Message #4 by "Carnley, Dave" <dcarnley@a...> on Fri, 20 Dec 2002 13:06:24 -0600
|
|
GET CHUNK
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Friday, December 20, 2002 10:26 AM
To: Access
Subject: [access] RE: Query question
The memo field is displayed in a textbox with a vertical scrollbar and no
horizontal scrollbar. However, it is based on a persisted query in the
queries tab. When I open that query the data is truncated at 256 characters
also.
|-----Original Message-----
|From: Thomas, Charles [mailto:CThomas@D...]
|Sent: Thursday, December 19, 2002 2:12 PM
|To: Access
|Subject: [access] RE: Query question
|
|
|How are you displaying the memo date information on your form i.e. textbox,
|combo box, list box?
|
| -----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Thursday, December 19, 2002 11:23 AM
|To: Access
|Subject: [access] Query question
|
|I have a Table with 5 memo fields. I have built a query on this table (and
|other linked tables) that returns these memo fields. This query is the
|DataSource for a form. It appears that the query is only returning the
|first 256 characters from the memo field and therefore the form is not
|displaying all the information. Is there a way to get the query to return
|all the data in the memo field?
|
|
|
|
|
|
|
Message #5 by "Thomas, Charles" <CThomas@D...> on Fri, 20 Dec 2002 15:26:01 -0500
|
|
Just to make sure, drop a textbox on the same form and type the following in
it:
=Len(<your memo field name>)
this way, you can see the exact amount of characters in the field. I tried
to duplicate the problem, but to no avail. If you like, you can send me a
copy of the file and I can work you through it.
-Charles
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Friday, December 20, 2002 11:26 AM
To: Access
Subject: [access] RE: Query question
The memo field is displayed in a textbox with a vertical scrollbar and no
horizontal scrollbar. However, it is based on a persisted query in the
queries tab. When I open that query the data is truncated at 256 characters
also.
|-----Original Message-----
|From: Thomas, Charles [mailto:CThomas@D...]
|Sent: Thursday, December 19, 2002 2:12 PM
|To: Access
|Subject: [access] RE: Query question
|
|
|How are you displaying the memo date information on your form i.e. textbox,
|combo box, list box?
|
| -----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Thursday, December 19, 2002 11:23 AM
|To: Access
|Subject: [access] Query question
|
|I have a Table with 5 memo fields. I have built a query on this table (and
|other linked tables) that returns these memo fields. This query is the
|DataSource for a form. It appears that the query is only returning the
|first 256 characters from the memo field and therefore the form is not
|displaying all the information. Is there a way to get the query to return
|all the data in the memo field?
|
|
|
|
|
|
|
|
|
|
View Cart
