Conditional formatting missing in menu 1

[iamareplicant]

Experts,

My client has an corporate-wide install of Access 2000. However, if I right click a text box, condtional formatting is missing (not greyed out, but completely missing).

However, this works in the VBA code:

txtText1.formatingconditions...etc...

But I need to be able to get to the built-in conditional formating window by right clicking on a text box.

Anyone know why this is missing from the shortcut menu?

TIA,

JBG

 

[Eupher]

Your form is open in design view? Otherwise, I have no idea...

Ken S.

 

[TheAceMan1]

How are ya iamareplicant . . .

I'm never known it to reside in any shortcut menu! In fact parsing the shortcut menu's for forms revealed this to be true.

However it can be placed on the shortcut menu if desired!

BTW . . . does it exist in its usual residence of Menubar - Format - Conditional Formatting?

See Ya! . . . . . .

 

[iamareplicant]

yup, i am in design view when i right click on a text box to format it.

And in Access 2003, condtional formatting shows up in the menu. So i assumed that in Access 2000, it showed up there as well.

But it seems not? If any of you have Access 2000, right click a text box in design view and let me know if ya see conditional formatting as a list choice?

 

[iamareplicant]

and nope, it doesnt exist in the regular menu bar

 

[TheAceMan1]

iamareplicant . . .

No go for me on access 2K . . .

In any case you can try resetting the toolbars. In a [blue]module[/blue] in the [blue]modules[/blue] window, copy/paste the following routine:

[blue]Public Sub qqq()
   Dim cb
   
   On Error Resume Next
   For Each cb In CommandBars
      cb.Reset
   Next
End Sub[/blue]

Open the immediate window

and type [blue]Call qqq[/blue] and hit enter.

[blue]Let me know the results! . . .[/blue]

See Ya! . . . . . .

 

[iamareplicant]

didnt do anything, but 'preciate the help regardless...

 

[iamareplicant]

wrong, it worked.....thanks ace...much appreciated