Search results for query: *

Thanks for assisting. I got it to work. Sometimes I think my brain goes out of its way to make me look stupid. Peter

I have created a new field in the source for my report as shown below: Final: [Preferred Name]+[Opening1]+[Opening2]+" "+[Sex]+[Self-Others]+" "+[Preferred Name]+" "+[Subject1]+" "+IIf([Subject2]<>" ",[Subject2],"")+" "+Preferred Name]+[Developmental] All fields referenced above are set to...

I have a table with several memo fields. I need to combine these to form 1 paragraph and place this on a report. I can combine the memo fields to form a new field, but this only creates a text field that can hold 255 characters. I need more so that I can view the whole field (more than 255...

I wish to control which objects are visible on a report. My users will select an option from a list box on a form. This will enter a value from 1 to 5 that is stored in a table. The report has 5 boxes drawn, all currently with the fillcolor set to white. I want to change the fillcolor to...

The data type set for the text boxes is Text, so I suppose the values will be zero-length-strings. Peter

The detail section in my report contains 5 text boxes - these are grouped according to one field in the table that contains the data. My problem is that, when inputting the data, not all fields will be used all of the time. Sometimes, the report will show all 5 text boxes with data, sometimes...

Finally got it working - thanks. Peter

There will be a command button that opens the report. Peter

Still can't get it to work. The images are not needed on the form. When using the form, the user selects one of four options held in a frame - each option is assigned a value from 1 to 4. When the user then views the report, one of 4 images is to appear depending on which option was selected...

Thanks - this works on the form. However, I can't get to selectively display the images on the report. Any more ideas would be appreciated.

I have a text box that will contain a value from 1 to 4. Beside this I will have a series of images in columns. Initially, all images will be invisible. I would like to be able to display a particular image depending on what the value in the text box is eg: if the value is 1, then the first...