Recent content by access my brain

Is there a way to limit the character size for a Memo box?. I need to get the Memo box to stop at 1000 characters when the user is typing and just stop typing like a text box, which limits you to 255 characters. Can anyone post some example code for this?!? thanks!

all sorted, you can force new page within the report header properties and create a cover page this way

Probably a really simple question...but....Can anyone suggest the simplest way of creating a cover page for a report? I read somewhere to use forcenewpage in the header but this is not a property option and i'm stuck TIA

thank you for your help I will keep trying

When I try the following I still get an error message =Min(ukstart,italystart) "The expression has invalid syntax, you may have entered an operand without an operator" also tried =Min([ukstart],[italystart]) and semi-colon as well

I have a form with several 'start' and 'end' date fields on it. I'd like to add another field which looks at all the start fields and gives the 'earliest date' record and also for the lastest date. this is a probably a really easy question but i'm getting nowhere :-( any help much appreciated

many thanks all sorted

I'm using access for the first time. I have a combo box on a form, I'd like users to select an item from the combo box and that will return all form records containing that item. The same as applying a form filter but easier for the user Is there a simple way to do this without VB script...