Recent content by amclfc

Works A Treat Thanks to all your input I've got it working like a treat. Super people. :D

? Thanks, this works: Private Sub Ctrl_Check_GotFocus() If Me.Ctrl_Res = "CS10" Then Me.Ctrl_Check.Locked = True Else Me.Ctrl_Check.Locked = False End If End Sub But when I try it for Null values like so I get a runtime 424 error "Object required", any help please?: Private Sub...

Lock field for a record if another field is null: I would like to stop users from entering a date in "Ctrl Closed" unless they have populated "Ctrl Reason" for any given record. Not sure how to do this. Any ideas would be greatly appreciated.

FIXED :D :D :D Turned out to be a reference problem to do with a missing active X control Thank you all very much

The problem seems to be null values as when I emulate the scenario with a table containing no null values in the date field being interigated then I have no problem, this is my latest attempt.... =Nz([Offer/Subscription End Date],"To be advised","From " & Format([Offer/Subscription Start Date]...

Thank you all once again..... I have just tried the following which should only try to format if there is a date if I have finally caught up. The fields being queried are date fields by the way with only null or dates by way of values =IIf(IsDate([Offer/Subscription End Date]),"From " &...

I think I get it now, will be back in a mo.......

Hi Vince =iif(isnull([datefield],'',format([datefield],"dd mmmm yyyy")) I get the error message "The function you entered can not be used in this expression." Same as just having =Format([Offer/Subscription Start Date],"dd/mmmm/yy") all on its own. I defo have an isolated problem with using...

Hi Rich =IIf(IsDate([Offer/Subscription End Date]),"Null","Valid") comes back with null when I have a date in the field [Offer/Subscription End Date] and comes back with valid when there is nothing in the field [Offer/Subscription End Date]. How does this help?

Hi Guys, you are being very helpful thank you, I still get the same error message with all our variants. When I try =Format([Offer/Subscription Start Date],"dd/mmmm/yy") all on its own I still get the error message. So I now think my problem is to do with format if you know what I mean. Why...

This is the first time I have tried to use the format function, I have just tried below and I still get the error message "The function you entered can not be used in this expression."????? =Format([Offer/Subscription Start Date],"dd/mmmm/yy")

Rich, I got the same error message with yours Uncle Gizmo, your =IIf(IsNull([Offer/Subscription End Date]),"Null","Not Null")came back with Not Null perplexed very am I This works fine (but wrong date formats): =IIf([Offer/Subscription End Date] Is Null,"To be advised","From " &...

ACCESS 97 Hi, I have a text box in a report and I am trying the following within expression builder: =IIf([Offer/Subscription End Date] Is Null,"To be advised","From " & Format([Offer/Subscription Start Date] , "long date") & " to " & Format([Offer/Subscription End Date] , "long date")) I...