Question:
Hi,
I have a long description for the query and am unable to wrap it up in one line or carry over to the next line. Actually my query title reads likes this.. Performance Index for Nuclear operations for the month of January 2005 and it should display like
Performance Index
for Nuclear operations
for the month of January 2005
I tried in the box for text in Query Properties by pushing Enter keys which I use to do for any long text column headers in a query. This does not work. Is there any way?
Thanks ion advance.
BWN
Answer:
Very much possible...
You can use Workbook which will solve ur purpose. For the user it will be just a link (like a query)
I guess, VBA Macro as well can do this.
_________________
Regards,
Parin
Answer:
Hi,
I have a long description for the query and am unable to wrap it up in one line or carry over to the next line. Actually my query title reads likes this.. Performance Index for Nuclear operations for the month of January 2005 and it should display like
Performance Index
for Nuclear operations
for the month of January 2005
I tried in the box for text in Query Properties by pushing Enter keys which I use to do for any long text column headers in a query. This does not work. Is there any way?
Thanks ion advance.
BWN
Why don't you try "Performance Index for Nuclear ops for Jan 2005"? It fits in and there is some extra space, and it does not obscure the meaning of your longer title. (I renamed a query in the dev system, your full title got truncated at 'Ja', the shortened title worked.)
Somebody may come up and say change this table or that, but I wouldn't recommend that. Next you'll want to change the field length of the Transport description field, see what I mean?
_________________
Keep smiling