Search results for query: *

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...

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?

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...

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?

If i have 2 tables, both of which contain a list of titles, is there a way to create a query to list all titles from both tables in one field?

Syntax error (missing operator) in query expresion '[tblLCDAssess].[Short Name] = Bees Test' I keep getting this error when i run a form that uses the below line of programming. The I assume i am misusing the comparison operator for matching 2 strings but i dont know what else to do. Ive...

I have created a form where i can scroll a drop down list of items. I can then chose an item and then use another drop down menu to chose another item. This form works perfectly when i open it from the main data base window and displays that there are 388 records. When i open this form from...