Recent content by jeffc

and when testing, the text box def grows, but doesn't grow enough to display all of the text. and the text gets cut off beforei t reaches the end of the textbox. Could it be because the report is based on a query? Maybe something limiting it in the query?

I should have mentioned that I did check that and it is set to 'yes'.

I have a pretty length field in a table that is for keeping issues with applications. When i try to create a report that shows issues by site, the text box does not display all of the text from the issues field. Any ideas? Thanks!

thank you!!!

Hello again! Hoping to use SQL to do this in a query. In a table I have linked to a text document (have to do it that way) there is a field that holds multiple values. Meaning there can be some fields with nothing, some with a -, soem with a 3 digit number, some with a single digit followed...

ha, i got it! I used your example and just made it CSTR() thank you!!!

Oooo...the SQL modification looks liek a good idea. But still new to the SQL. Here is the SQL that links the 2 databses: JOIN tblTPs ON tblCPs.[Time Profile ID] = tblTPs.ID the tblCPs.[Time Profile ID] is the one that is text...so do i do this: cint(tblCPs.[Time Profile ID])?

Hello! I need to join 2 tables, 1 table with all of the fields, and another with just 2. The link between the 2 tables is an ID field in field 2 wich is long integer. The problem is, the ID field in table 1 that correlates to the ID field in table 2, is in the datatype text. I cant change...