Recent content by vicktown

Yes i have tried this, thanks you for your efforts but i am still getting the same problem. It seems that these expressions are turnign a memo type into a 255 character text type. Any more ideas?

It causes the same problem. tblParagrpah.TEXT is still being truncated. Is it even possible to call a Memo from an expression and have it stay as a memo style field?

Sory about those [b]'s . they arent actually in my coding. It was a mistake putting them thre. Ok i have nothing in the Format property box. This problem only occurs when i call a field from an expression, and not when i call the field straight up. Somehow the expression in the query is taking...

The portion of the SQL that includes this expresssion is here: IIf(IsNull([tblParagraph]![TEXT]),"The text for this paragraph has not yet been entered into the databse",[tblParagraph]![TEXT]) AS Expr3 tblParagrpah.TEXT is of Memo type but is being truncated.

I am calling values from a memo field type using a query expression. The memo is being truncated. How do i stop this? This is my expression: Expr3: IIf(IsNull([tblParagraph]![TEXT]),"The text for this paragraph has not yet been entered into the databse",[tblParagraph]![TEXT])

I am calling values from a memo field type using a query expression. The memo is being truncated. How do i stop this? This is my expression: [b]Expr3: IIf(IsNull([tblParagraph]![TEXT]),"The text for this paragraph has not yet been entered into the databse",[tblParagraph]![TEXT]) [b/]

I have created an expression in a query using an IIF statement. But i am having a problem because the text is being truncated. The information coming in is set to Memo type but a character length is being set once it comes into the query expression. How can i get around this and stop the...

Ok dont worry about it, i worked around this problem. thanks anyway people

Tried it, nothing. thanks though

For some reason a 66 page report is coming up with 123 pages on the record selector with everyother page being blank. Yet the number of pages on the actual report says 66. Whats the deal with this?

Thansk for the tip, unfortunately it didnt do the job The exact error message is this: Syntax error in query expression 'First([IIF(IsNull([tblAssessPar.Assess]);"";[tblAssessPar.Assess])'. , for this line of code in the source data properties box...

Thanks I am using the exact method as one of the examples from the help menu but am getting an error message. "Syntax error (comma)" I have looked over my command and can find no problems. Do i need to do soemthing else or am i just missig something. here is my line of code...

Hi, I am trying to get a text box (Texst box 30)on a form to print the words "NO DATA" if a certain text feild from a record is empty. The text box and reference field for the record are being accessed in a report's section header from a query. I am trying to use the IsEmpty or IsNull...

OK i know what OnFormat is now. Should I use an event procedure in the OnFormat of that text box's footer? And if so what should the code look like if I dont actually want to change teh information in the tables? What im looking to do is to see if a field has data, if it does then i want it...

What is teh format event procedure?