String Text

[bigbadbess24]

I have created a report that has string text from a query I created. The query, with the string text, take the information from a table. When I run the report the string text gets cut off (The box is big enough to hold the information). The table I have is a linked table to a text file that gets imported from a program. I try creating the same table but not having it linked and the string text worked.

Is there some way I can get around this? Is there something in the linked table that is stoping the string text?

 

[KeithG]

Does the string appear correct in the table and not the report or is it incorrect in both?

 

[bigbadbess24]

The string text appears to be the same in the report as it is in the query for the linked table.
In the non linked table, the string text gets cut off in query (even though in the expersion builder it shows everything) but it shows everything in the report

 

[David R]

Is it a Memo field, by chance? I think they get cut off at 255 characters in certain reports...?

 

[bigbadbess24]

No its not. The linked table and the non linked table are set up the same way. Everything matches. The string text only gets cut off from the linked table and not the non linked table. (keep in mind I created the string text in the query)

 

[KeithG]

What data type is the field that is getting cut off? Is it text? If so what do you have the field length set to? Is the string more that 255 characters long?

 

[bigbadbess24]

i did not know that you could set the string to 255 characters long in a query, where can that be done?

 

[KeithG]

not the query in the table

 

[bigbadbess24]

I knew you where referring to that but in the table, the field for sex is set for 255 but so is the one for the non linked table but it still works

 

[KeithG]

Is there anyway you can post your DB? I am stumped, maybe if I can see the tables I can figure it out.

 

[bigbadbess24]

I attached the database. When you run the report Add/Drop just hit ok the error messages. The query with the string text is called "qry Add/Drop Student Data (active)" The table with the student info is called "tbl STUDENT DATA - ACTIVE". Thanks for any help you can give me.

 

[bigbadbess24]

Can anyone help me with this?

 

[KeithG]

I would breakdown string text and put it into a couple text boxes on the actual report.

 

[bigbadbess24]

That is not going to work. Its to much work and its hard to try to put it in to boxes and line them up together. Thanks for the idea though

 

[modest]

I dont understand why you don't just include the text string in a textbox on the report itself. You don't need it in the query.

="Due to the change in your " & [Son/Daughter] & "..."

 

[KeithG]

Well it will work, if you want to put in the time and effort.

 

[bigbadbess24]

Cause it is to big. Its over 255

 

[KeithG]

that is why you need more that one text box. Have you ever tried using the Mail Merge feature between Access and Word because this is a letter correct?

 

[bigbadbess24]

Yes it is. I kind of worked it out. I just made two string text. Broke it up into two sections. As you said "Well it will work, if you want to put in the time and effort." Just have to be creative. Thanks for your help.

 

[KeithG]

No problem, I'm glad you figured it out