Recent content by martinbanks

Outstanding, thank you. I could've sworn I tried that but evidently not. For anyone else having the same problem though, the solution to making it appear still lay in the Can Shrink property. Set that to No and it vanishes from the print but not the report view. Set it to Yes and bingo :)

:( SetWarnings = False doesn't suppress Parameter boxes it seems.

I have tried it as a text box but I don't know how to have a text box just display text. It seems to want to be bound to something. I just tried adding in a field to the query this report reads with the formula: Expr3: IIf([SortLength]>0,"x","") SortLength will always be above zero, so I...

I have a report which shows dimensions, which are in text boxes, and in between them I need 'x's ie 25½ x 16 x 2¾ I have put the 'x's in as labels and they appear fine on the report view but when you print it they vanish. The Visible property sheet is Yes and the Display When is Always. There...

When I try to switch it to Rich Text it tells me the setting isn't valid on this property :( I'm using Access 2007 btw

:( what about achieving it indirectly; can I get a box to change it's size dependent on each result (eg ACF is much shorter than Topline Contract Furniture) and then another box that will change it's Left property to sit up next to it Is that possible?

Varying text box size dependent on each example Is it possible to have the text size vary within a text box on a report? I am trying to get COMPANY - O/N - Del Date to display as COMPANY - O/N - Del Date

The different grades of foam. Anyway, it seems like I've been in the wrong section and should be using reports. Thanks for all the help.

Nice one, pictures should make it clearer. Pic 1 is the form for entering, as you can see it accommodates up to 9 products (the bottom row is just partly visible) and each product, once selected, fills in with it's variations (a max of 10, though generally there are just 5) Pic 2 shows the...

I think I have confused you with my poor use of terminology. I am fairly sure that the tables etc are normalised correctly. I was saying that the form shows the same grid of boxes for 9 products, but sometimes a customer will order more products than that on one order. Making the form show 20...

I am creating an order entry system and am having a few hiccups/complaints. I am very new to Access (about 2-3 months experience) so don't know many of the possible solutions I could explore, so I'm really just looking for points in the right direction, I don't expect anyone to write my database...