Display a year

[GerryGoldberg]

I have a form that is based on a table that contains a numeric field that represents a year value. I would like the user to be able to enter two OR four digits for the year but have the form always display a four digit year. I have tried various combinations for Format and Input Mask but can't seem to get it right. Can anyone steer me in the right direction.

Thanks,

 

[JeremyNYC]

You'll have to write the logic yourself. You'll have to figure out how to handle the two-digit years: there's got to be break point for making some of them start 20 and some of them start 19, unless you want them all to start 19. You'll probably want to do some overall validation, to make sure that all values are within a certain range.

I would say, junk it as an idea. First off, dates should be stored in date fields. Second, this is a lot of code to write. Third, we all saw what a mess two-digit years created a few years ago, and there's no reason to revisit that. Sometimes users have to learn to deal with the way software functions. Just require that the value be between a give range or use a date field, would be my advice.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[FancyPrairie]

Since it's a numeric field I don't believe formatting it is going to help. Try this to see if it works for you.

On the AfterUpdate event of the field type something like this (where txtintNumber is the name of your text box):

Private Sub txtintNumber_AfterUpdate()

If (txtintNumber < 100) Then txtintNumber = 2000 + txtintNumber

End Sub