How to retain a partial date in a text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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

MsgBox Me![ControlName].Text
 
Thank you! That enables me to do what I intended in a very straightforward
manner.

fredg said:
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?
Click to expand...

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

MsgBox Me![ControlName].Text
Click to expand...
 
Back
Top