Comment Question

[Guest]

I have a comment box in a program that I'm trying to query from. In this
comment box, there are multiple lines of information.

I'm trying to create a query that will pull all the information from the
comment box. Only problem is, when I run the query, it only pulls the first
line of text in the comment box.

Is there a way I can gather all of this information, or do I have to put
everything on the first line so that it picks it up?

 

[Dirk Goldgar]

I have a comment box in a program that I'm trying to query from. In
this comment box, there are multiple lines of information.

I'm trying to create a query that will pull all the information from
the comment box. Only problem is, when I run the query, it only pulls
the first line of text in the comment box.

Is there a way I can gather all of this information, or do I have to
put everything on the first line so that it picks it up?

Are you sure it's really pulling only the first line? In a query
datasheet, you normally won't see more than the first line of a
multi-line field unless you click into the field and start "arrowing
around". What do you see if you click into the field and press Shift+F2
to open the zoom box?

 

[Guest]

Hi Metaltecks,

My guess is that your query is actually picking up the entire Comments
field, however, if you have the default row height then you will not see any
data that occurs after a line feed (or CrLf: Carriage Return Line Feed). Run
your query. Then try expanding the row height (Format > Row Height). Set it
to some number greater than the default of 12.75, for example 40.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Vinson]

Is there a way I can gather all of this information, or do I have to put
everything on the first line so that it picks it up?

Your best bet would be to display the results of the query on a form
(with a suitable size textbox) rather than a query datasheet. As noted
elsethread, the data's there, it's just not visible because you're
using the very limited query datasheet to view it.

John W. Vinson[MVP]