Search results for query: *

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?

IS there a way i can use an if statement as a Control Source on the Data Tab in the properties box for that field. And if so what would it look like?.

GOod day, I am working with an old database that is very large. I am creating a report that much deal with many blank fields for some records. Is there a way to set a default value on a report for fields that are empty?

I have recently developed a database for a company that I am working for. I would like to create a Help option available from the help drop down menu similar to the contents help screen for Access. I have no clue where to start but would love some advice on what to do. Thanks

How do I make a text box have different text based on the value of another variable?

How can I add a field to a linked table? When i try and add a field i get a message saying i cant make property changes on linked tables, is there a way around this?