I have a text box named Start_Date I want to hide if the value in my visible=false text box is "Today" that's literally a text string "Today" but these do NOT work:




edit: Ooops, sorry, there is a text box named End_Date I want to hide if the value in Start_date contains the text string "Today" ... don't know if I made that perfectly clear.

Any help would be greatly appreciated ...

This post has been edited by bakersburg9: Apr 17 2012, 12:49 PM

bakersburg9,

Which form/control event contains this VBA code? (When does it fire?)

Have you tried this:

Me.End_Date.Visible = Not(Me.St_Date = "today")

Hope this helps,

Dennis

Hi Steve,

Does this work?

Me.End_Date.Visible = Not (Me.St_Date="today")

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

EDIT: Oops, too slow. Sorry... (IMG:style_emoticons/default/blush.gif)

This post has been edited by theDBguy: Apr 17 2012, 01:02 PM

on open event




I've tried everything under the sun, including the suggestions here, nothing works :-(

bakersburg,

The problem is that the Open event only fires once - when the form opens. You should probably move the code to the AfterUpdate event of the St_Date, and then include a call to run St_Date_AfterUpdate in the form's OnCurrent event.

That way it will fire when the textbox value changes, or when the user navigates to a different record.

Hope this helps,

Dennis

**scree-e-e-e-e-ch !!! **
problem - that's not an option - I don't think

these are:

On Click
On Got Focus
On Lost Focus
On Dbl Click
On Mouse Down
On Mouse Up
On Mouse Move
On Key Down
On Key Up
On Key Press
On Enter
On Exit

bakersburg,

In your original post, you described it as a "text box" - is this not correct? If it's a label, you need to explain what causes the label to change. THAT event is where the visible/invisible code will need to go.

Dennis

That's correct - it IS a text box - don't know where I said anything about a label - if I erroneously used a label, I think I'd know :-)

bakersburg,

A textbox DOES have an AfterUpdate event. It fires after the user types in a value and either hits [Enter] or leaves the control to move to another one.

If that event is not available to the control, you should verify that it is a textbox by opening your form in Design View, selecting the control, and looking at the Property Sheet. The second line, right under the words "Property Sheet" should say "Selection type:" followed by the type of control you're currently selecting.

Dennis

ahhhh the light bulb just went on - you are thinking this is a text box on a FORM - I have the question in the wrong forum s/b Access REPORTS - that's the problem !

bakersburg,

That is helpful. In that case, I would use the Format event for the section where the textbox appears. That event fires once each time the section is printed. So, if the textbox is in the Detail section of the report, use the Detail section's OnFormat event.

Dennis

Didn't work:

bakersburg9,


Can you be more specific? Did you get an error message? Is the textbox always visible? Is it never visible? What?

Perhaps you could put a Breakpoint on that line of code, and then when you open your report and the code pauses there, you can see the two values to see if they are comparing properly.

Dennis

Great news ! The advice was spot-on, it's that the code was the problem - THIS worked :


THANK YOU !!!!!!

(IMG:style_emoticons/default/cool.gif)
Steve