Search results

Chris, Sweet! That works perfect. I don't know how long I've been trying to get something like that to work. Thanks for your help! Toby

Adam, The notelines are evaluated when a report opens. One of the reports recordsource is a table containing 20 fields (NoteLine1, NoteLine2, ect.) On the report, there is one textbox with its control source set to =NoteBlock([NoteLine1],[NoteLine2] ect). The textbox is set to grow for the...

Hi everyone! :) I really have no experience in Arrays and they are very confusing. I' would like to change this code (total of 20 if statement) and make it loop. Where I'm running into a problem is using an array :confused: in a concatenated string starting at the last position and moving...

Use a query as a record source for your report. With a query you can use "expressions" to filter records as needed. You can find examples of query criteria in your access help. Toby

Here's what your looking for. I just happened to have a link on my desktop. http://office.microsoft.com/en-us/access/HA011494721033.aspx Toby

Need help...Almost there Hi All, So far I've decided to use one textbox and use IIf statements on my report. Is there any way to use multiple fields or variables with IIf? For example: A1$ = IIf(ISB("NoteLine2 through NoteLine20"), "", NoteLine1 & CR$) What I'm trying to do is keep lines...

A quick solution is to run this code from a command button on a form. docmd.RunCommand acCmdLinkedTableManager

I'm seeking help on a report design. On the group footer, there are a total of 20 horizontal textboxes. Textbox 1 at top and continues down to 20. This section of the report will display user comments entered from a previous form also displayed in the same format. What I would like it to do...