Search results

TextBox I'm not sure what 'x' stands for. If it is the value of the texbox you can do the following. In the After Update Event of the textbox put something like this: If Me.textbox > 0 Then Me.textbox.FontBold = 1 Else Me.textbox.FontBold = 0 End If 'replace textbox with the actual...

Combo On the Format Tab, set Column Count to 3. On the same Tab you can set the Column Width.

Jpeg Try changing the extension of the image from JPEG to JPG.

Ucase You're welcome.

Ucase This also underlines the remark I made earlier. Giving all fields, object names etc. meaningful names can save you a lot of headache later. Good Luck.

Ucase OK, tried that form. The problem was that the field name was incorrect, something like Text 117. Rename the Combo Box to cboState and then put this code in the After Update. If Me.cboState = "AB" Or Me.cboState = "BC" Or Me.cboState = "MB" Then Me.Address_1 = UCase(Me.Address_1) Else...

Ucase I downloaded the db. In the Form DRAFTS (Kodi) I put the code in the After Update Event of the Field State, and it works fine. The Field Address_1 gets formatted as needed. What error are you getting? Tip: use a lookup table for the field State. Some advice. It is good practice not to...

UCase Sorry, can't unzip the file. It tells me it's an unknown format.

Ucase I have tried in my db, and it works fine for me. Should work in any Access version. Perhaps you can post your db (without data), and I'll have a look.

Required Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=87223&highlight=required+field

Ucase Sorry, my fault. This goes in the After Update Event of the field State Try this: If Me.State = "AB" Or Me.State = "BC" Or Me.State = "MB" Or Me.State = "NB" Or Me.State = "NL" Or Me.State = "NS" Or Me.State = "NT" Or Me.State = "NU" Or Me.State = "ON" Or Me.State = "PE" Or Me.State =...

Ucase The code goes in the After Update Event of the field 'State'.

Path How about you establish the path for one document and then use that data to do a Search and Replace in the table.

State Try this: If Me.State = "AB" or Me.State= "BC" or "etc." then Me.ActiveControl = UCase(Me.ActiveControl) Else Me.ActiveControl = StrConv(Me.ActiveControl, vbProperCase) End if

Sum How about: =Sum([Field1]) + Sum([Field2])

Wizard Do you have the Wizard checked (on) in the Toolbox?

Tab Color I haven't found such code. I stopped using the Tab Control. Instead I draw two Rectangles, a large one for the main area and a small one to simulate the actual tab. I can set the colors easily and I use the SpecialEffect settings to simulate the tabs to go up and down. Coding is a...

Processes Probably the easiest solution is to ad a Yes/No Field to the table, which will give you a Check Box on the form. That Field will indicate if the Process has been completed or not. On the form you can put some code in the After Update Event of the Check Box that, when checked, will...

Great You're welcome :)

Validation Try something like this in the Before Update Event of the field: If Len(Me.yourfield) < 10 Or Len(Me.yourfield) > 11 Me.yourfield = Left(Me.yourfield, 11) 'message box optional MsgBox "Text must be 10 or 11 characters, vbOKOnly, "" 'set focus to another field...