Recent content by morlan

I wan't access to automatically size the column widths in a list box. Is this possible or would I have to set each width in the 'Column Widths' property?

If me.Control IS Between Value and Value Just a quick one. I need to check if control's value is between 10 and 20. How do I do this? If me.Control IS Between Value and Value

Yeah, conditional formatting works fine but I need to do this in VBA.

Report: Changing the colour of a control depending on its value. Hi, I have a report based on a query. I want to change the colour of the controls background depending on its value. Here is a sample of the query: Venue - Rejected London - 1.00 Glasgow - 1.50 Bristol - 2.10 Anything above...

Hi guys. Just wondering if it's possible to hide certain fields in a report with VB. Here's a screen grab of the report: The date fields and the 'AppsTaken' fields are duplicated. For Christine Davies, '28/02/2004' and '12apps' is listed 3 times whereas it only needs to be listed once. Is...

Perfect, thanks dcx. :cool:

Thanks mate, I think I've sorted it. :)

Hi guys, I have 4 text boxes that are used to input a bank account number. I have set the text boxes with an input mask of 0000 which stops the user from entering more than four numbers in each box. I want to automatically set focus to the next box when the user has typed in 4 characters. I'm...

Thanks dcx, that's a much better way of doing it!

Hi, I've been looking though the search and can't seem to find anything. I have fields on my form that must be filled before the user can add a record. If the user tries to add a record, and the required fields are not filled, they will get a popup message box for each missed field. What would...

GOT IT!! Managed to find it Thanks for the help.

I'm clicking on the tab in design view and only brings up the page property. How do I get the tab control property? For the page property (in format) I have: Caption Picture Picture type Page index Visible Left Top Width Height None of which have an option 'none' :confused:

What? In the propery sheet of the form? Where exactly is it? Cheers

Hi, I was just wondering if there was a way to stop a user from clicking the tabs in my form to switch pages. I want them to use a 'Next' and 'Back' button instead. This is because each page needs to be validated before the user can continue to the next one.

Bump