Search results

I had a problem like this when I changed the default lable names and had to do a move of the lables and text boxes. I did this on the format event. It was a lot of pain you have to find out what the position of each object is so you can move them back if they are not null. If IsNull(Me![Jan])...

create a new query and put the syntax that I gave you in a new field eg: New fieldName: [Field1]&[Field]&[Field3]. I hope this helps

Just create a Hyperlink to the file. (Light forms)

If IsNull(Me!YourTextBox) Then Me![Me!YourTextBox].Visible = False ElseIf IsNull(Me!YourOtherTextBox) Then Me![Me!YourOtherTextBox].Visible = False End If

Place a book mark on a continuous form

You have to start from the parent object then drill down to the object you want the event to happen to. Worksheets("Sheet1").Range("C1 37").Clear

The ampersand is the concatenation function [field1]&[field2]&[field3]=field1field2field3

If the format is the same eg. 123abc 123abc Then you can parse the letters or numbers from the string

On Click Event of the calendar Subformname!textbox.value=Calender1.value