How to retain a partial date in a text box

[Guest]

If a partial Date field is entered in an Access form, Access automatically
infers a complete date (e.g., an entry of 9/05 (MM/YY) is automatically
modified to 9/5/2006).

I want to manipulate the partial date for special processing; however, the
Access modification occurs before the BeforeUpdate event, so at that point
the input has already been changed.

Can anyone tell me how I can read and record the actual text as input into
the form before Access changes it?

 

[fredg]

If a partial Date field is entered in an Access form, Access automatically
infers a complete date (e.g., an entry of 9/05 (MM/YY) is automatically
modified to 9/5/2006).

I want to manipulate the partial date for special processing; however, the
Access modification occurs before the BeforeUpdate event, so at that point
the input has already been changed.

Can anyone tell me how I can read and record the actual text as input into
the form before Access changes it?

Read the control's Text property.
Code the control's BeforeUpdate event:

MsgBox Me![ControlName].Text

 

[Guest]

Thank you! That enables me to do what I intended in a very straightforward
manner.

If a partial Date field is entered in an Access form, Access automatically
infers a complete date (e.g., an entry of 9/05 (MM/YY) is automatically
modified to 9/5/2006).

I want to manipulate the partial date for special processing; however, the
Access modification occurs before the BeforeUpdate event, so at that point
the input has already been changed.

Can anyone tell me how I can read and record the actual text as input into
the form before Access changes it?

Read the control's Text property.
Code the control's BeforeUpdate event:

MsgBox Me![ControlName].Text