Change data on Date

Thanks Ken where do i place this code..............Thanks Bob
=IIf([tbAge] > 3, Replace([cbsex], "F", "M"), [cbsex])

"Ken Snell (MVP)" <kthsneisllis9.DeleteThis@ncoomcastt.renaetl> wrote in message
news:uF2wqYpJJHA.1264@TK2MSFTNGP06.phx.gbl...
> Generic expression:
>
> =IIf([AgeOfHorse] > 3, Replace([SexOfHorse], "F", "M"), [SexOfHorse])
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
>
>
> "Bob Vance" <rjvance.DeleteThis@ihug.co.nz> wrote in message
> news:%23u63MooJJHA.1156@TK2MSFTNGP04.phx.gbl...
>> On My form I am Trying to write a code if the Horse is 3 years old F
>> changes to M (Text)
>> If [cbSex] > Year 3 [cbDateof Birth] repalce F with M
>>
>> --
>> Thanks in advance for any help with this......Bob
>> MS Access 2007 accdb
>> Windows XP Home Edition Ver 5.1 Service Pack 3
>>
>>
>
>
 >> Stay informed about: Change data on Date 

Thanks Ken Got it put it in a Query!
Regards Bob

"Bob Vance" <rjvance DeleteThis @ihug.co.nz> wrote in message
news:ugkj0h8MJHA.5232@TK2MSFTNGP05.phx.gbl...
> Thanks Ken where do i place this code..............Thanks Bob
> =IIf([tbAge] > 3, Replace([cbsex], "F", "M"), [cbsex])
>
> "Ken Snell (MVP)" <kthsneisllis9 DeleteThis @ncoomcastt.renaetl> wrote in message
> news:uF2wqYpJJHA.1264@TK2MSFTNGP06.phx.gbl...
>> Generic expression:
>>
>> =IIf([AgeOfHorse] > 3, Replace([SexOfHorse], "F", "M"), [SexOfHorse])
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>>
>>
>>
>> "Bob Vance" <rjvance DeleteThis @ihug.co.nz> wrote in message
>> news:%23u63MooJJHA.1156@TK2MSFTNGP04.phx.gbl...
>>> On My form I am Trying to write a code if the Horse is 3 years old F
>>> changes to M (Text)
>>> If [cbSex] > Year 3 [cbDateof Birth] repalce F with M
>>>
>>> --
>>> Thanks in advance for any help with this......Bob
>>> MS Access 2007 accdb
>>> Windows XP Home Edition Ver 5.1 Service Pack 3
>>>
>>>
>>
>>
>
>
 >> Stay informed about: Change data on Date 

"Bob Vance" <rjvance.TakeThisOut@ihug.co.nz> wrote in message
news:eo$CBn9MJHA.2824@TK2MSFTNGP06.phx.gbl...
> Thanks Ken Got it put it in a Query!

Or use it as the expression for a textbox's ControlSource property.
--

Ken Snell
<MS ACCESS MVP>






> Regards Bob
>
> "Bob Vance" <rjvance.TakeThisOut@ihug.co.nz> wrote in message
> news:ugkj0h8MJHA.5232@TK2MSFTNGP05.phx.gbl...
>> Thanks Ken where do i place this code..............Thanks Bob
>> =IIf([tbAge] > 3, Replace([cbsex], "F", "M"), [cbsex])
>>
>> "Ken Snell (MVP)" <kthsneisllis9.TakeThisOut@ncoomcastt.renaetl> wrote in message
>> news:uF2wqYpJJHA.1264@TK2MSFTNGP06.phx.gbl...
>>> Generic expression:
>>>
>>> =IIf([AgeOfHorse] > 3, Replace([SexOfHorse], "F", "M"), [SexOfHorse])
>>>
>>> --
>>>
>>> Ken Snell
>>> <MS ACCESS MVP>
>>>
>>>
>>>
>>>
>>> "Bob Vance" <rjvance.TakeThisOut@ihug.co.nz> wrote in message
>>> news:%23u63MooJJHA.1156@TK2MSFTNGP04.phx.gbl...
>>>> On My form I am Trying to write a code if the Horse is 3 years old F
>>>> changes to M (Text)
>>>> If [cbSex] > Year 3 [cbDateof Birth] repalce F with M
>>>>
>>>> --
>>>> Thanks in advance for any help with this......Bob
>>>> MS Access 2007 accdb
>>>> Windows XP Home Edition Ver 5.1 Service Pack 3
>>>>
>>>>
>>>
>>>
>>
>>
>
>
 >> Stay informed about: Change data on Date 

Thanks Ken, would not work in a textbox Control source...thanks Bob

"Ken Snell (MVP)" <kthsneisllis9 RemoveThis @ncoomcastt.renaetl> wrote in message
news:u1%238t6%23MJHA.5692@TK2MSFTNGP04.phx.gbl...
> "Bob Vance" <rjvance RemoveThis @ihug.co.nz> wrote in message
> news:eo$CBn9MJHA.2824@TK2MSFTNGP06.phx.gbl...
>> Thanks Ken Got it put it in a Query!
>
> Or use it as the expression for a textbox's ControlSource property.
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
>
>
>
>
>> Regards Bob
>>
>> "Bob Vance" <rjvance RemoveThis @ihug.co.nz> wrote in message
>> news:ugkj0h8MJHA.5232@TK2MSFTNGP05.phx.gbl...
>>> Thanks Ken where do i place this code..............Thanks Bob
>>> =IIf([tbAge] > 3, Replace([cbsex], "F", "M"), [cbsex])
>>>
>>> "Ken Snell (MVP)" <kthsneisllis9 RemoveThis @ncoomcastt.renaetl> wrote in message
>>> news:uF2wqYpJJHA.1264@TK2MSFTNGP06.phx.gbl...
>>>> Generic expression:
>>>>
>>>> =IIf([AgeOfHorse] > 3, Replace([SexOfHorse], "F", "M"), [SexOfHorse])
>>>>
>>>> --
>>>>
>>>> Ken Snell
>>>> <MS ACCESS MVP>
>>>>
>>>>
>>>>
>>>>
>>>> "Bob Vance" <rjvance RemoveThis @ihug.co.nz> wrote in message
>>>> news:%23u63MooJJHA.1156@TK2MSFTNGP04.phx.gbl...
>>>>> On My form I am Trying to write a code if the Horse is 3 years old F
>>>>> changes to M (Text)
>>>>> If [cbSex] > Year 3 [cbDateof Birth] repalce F with M
>>>>>
>>>>> --
>>>>> Thanks in advance for any help with this......Bob
>>>>> MS Access 2007 accdb
>>>>> Windows XP Home Edition Ver 5.1 Service Pack 3
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
 >> Stay informed about: Change data on Date