Search results for query: *

Thank for you help I think I found the problem. I tried importing fields to new database and got this error "Attachment fields are not supported in the MDB or ADP database formats. If attachment fields are included in the source database tables, those fields will not be imported." Looks like a...

I have tried the code in a new database and it works. But still not working in the updated database. Do I have to re write the whole of old database or only the reports?

I had tried =[Starter] & Chr(13) & Chr(10) & [Fish Course] & Chr(13) & Chr(10) & [Main Course] & Chr(13) & Chr(10) & IIf([Vegetable1]>"",[Vegetable1]) & Chr(13) & Chr(10) & [Vegetable2] & Chr(13) & Chr(10) & [Vegetable3] & " " & [Vegetable4] & Chr(13) & Chr(10) & [Desert] & Chr(13) & Chr(10) &...

Sorry don't understand. What modified expression you fixed for me????

Yes running in trusted mode. Yes I've tried it with just one set of Chr(13) & Chr(10).

Yes. All the fields are in the form record source. If I omit the Chr(13) and Chr(10) it all works but all on one line. The code I have is =[Starter] & Chr(13)& Chr(10) & [Fish Course] & Chr(13)& Chr(10) & [Main Course] & Chr(13)& Chr(10) & IIf([Vegetable1]>"",[Vegetable1]) & Chr(13)&Chr(10) &...

Thanks for your reply. Just tried that and with a new text box and a unique name, still the same error message

Thanks. Just tried that with a new text box with a unique name, still the same error message

I am using Microsoft access 2007 When I use the following codes in the Control Source of the Property Sheet I get #Name? error on the form vbCrLf,………vbCr,………vbLf,………VbNewLine, and Chr(13),………Chr(10),………Chr(13)+Chr(10),………Chr(13) & (10),………with and without the $ sign The Chr$(13) & Chr$(10)...