Recent content by ashmanuk

Hello again, I eventually got the sub reports working but as suspected by both of us it didn't solve the spacing issues I was having! However, I have now found the code required to force a new line within a text box, entering Chr(13)& Chr(10)will force a new line: =[Field1]& Chr(13)& Chr(10) &...

I have tried setting up the sub reports, and it looks like it might work, however I am unsure about how to link the report and subreport to bring up only the fields required for that entry rather than all the records in each sub report! Hope that makes sense?!

Ha ha, well at least your honest, ill give it a go now then matey

Sorry for taking a while to reply.. I understand what you are saying Zoller, but I dont think this will work either for the same reason that I would have to leave sufficient space in the detail section of the report for the sub report to be dispalyed if there is data there. The only way I...

OK, thanks for your help, I could not use the individual fields though because then I would have to make room for them in the Detail and the space would be there even if there was nothing being displayed! Also, having a placeholder for a blank field in this case would not work, as there are a...

That is originally how the report was set up, however the these fields are arranged above each other like this (headings 3 and 4): Heading1 Heading2 Heading3 Heading4 [fielda] [fieldb] [field1] [field4] [field2] [field5] [field3] [field6]...

Hi there, I have a report that shows multiple fields in a text box. This works fine using the =[field1] & [field2] etc... However I was wondering if anyone knew of a way to make the next field appear on a new line as this would make my report look a lot neater and easier to read! I cant find...

Oh right! Well its good that you have told me about that one its had me stumped for a while! Thought i was going loopy! Cheers for that mate

Cheers mate that has got it going. If you dont mind me asking though, how did that solve the problem? Thanks for your help

If I do that though then the report does not know where to get the data from for that field. It comes up with a diolog box requesting the parameters for the renamed field. Sorry if I am getting the wrong end of the stick!? Also the data that is being displayed in this report is from a query...

The report displays #Error in the field in question.

No, why would I need to do this? Thanks

The field is from a query. I have already tried somthing similar to this and my latest attempt is =[fieldname]/12 (similar to what you suggested!). This does not work though! Any other ideas?! Thanks

Hi there quite a simple question really: I have got a report which displays the value of a field in months. This needs to be shown in years however. Quite simply I just need to know what the code is that you put in the control source of the field to make a division calculation. (As in divide...

Yes, its worked! Thanks a lot for that one mate!