VBA, count down and disable a date field

count down and disable a date field

Author	Message
MaryAn #1 / 4	count down and disable a date field I have a field called txtExpirationDate which is set to Date() set with a command button cmdSalePending. I want to have it "reset" itself to zero-length once the Date()=the present date. i have tried If txtExpirationDate=>Date() Then txtExpirationDate="" it's not working. can anyone help? Thanks! MaryAnn
Sat, 17 Jul 2004 01:03:03 GMT

Bush #2 / 4	count down and disable a date field What might be happening is, the text you've entered on the form (or that is appearing on the form) is being interpreted as Text/String. I recommend: If DateValue(txtExpirationDate) <= Date Then txtExpirationDate = "" End If Quote: >-----Original Message----- >I have a field called txtExpirationDate which is set to >Date() set with a command button cmdSalePending. I want to >have it "reset" itself to zero-length once the Date()=the >present date. i have tried >If txtExpirationDate=>Date() Then >txtExpirationDate="" >it's not working. can anyone help? >Thanks! >MaryAnn >.
Sat, 17 Jul 2004 06:21:02 GMT

John Vinso #3 / 4	count down and disable a date field Quote: >I have a field called txtExpirationDate which is set to >Date() set with a command button cmdSalePending. I want to >have it "reset" itself to zero-length once the Date()=the >present date. i have tried >If txtExpirationDate=>Date() Then >txtExpirationDate="" >it's not working. can anyone help? Is the table field behind this textbox a Text field, or a Date/Time field? If it's Date/Time, you should set it to NULL; "" is a text string, and a Date/Time is NOT a Text string, it's a double float number. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public
Sat, 17 Jul 2004 07:31:38 GMT

John Spence #4 / 4	count down and disable a date field Try setting the control to null. If txtExpirationDate=>Date() Then txtExpirationDate = Null Quote: > I have a field called txtExpirationDate which is set to > Date() set with a command button cmdSalePending. I want to > have it "reset" itself to zero-length once the Date()=the > present date. i have tried > If txtExpirationDate=>Date() Then > txtExpirationDate="" > it's not working. can anyone help? > Thanks! > MaryAnn -- John Spencer MS Access MVP UMBC-CHPDM
Sat, 17 Jul 2004 07:51:11 GMT

Page 1 of 1

[ 4 post ]