Any other thoughts on Time Zone Code

[JHumbert]

I need a code to show the correct time in a text box based
on the time zone a record is in. The base time would be
Central and I need it to show the correct current time
based on the state listed in my state text box. Does
anyone have a working code to do that?

 

[Douglas J. Steele]

See whether the code Randy Birch has at
http://www.mvps.org/vbnet/code/locale/gettimezonebias.htm helps.

(Note: you sometimes need to be careful with code from Randy's site, as it's
aimed at VB programmers. That means that sometimes the instructions for
forms won't work in Access, because of the differences in how form controls
work between the two. Looking quickly at this particular page, though, I
think it'll work in Access without any problems.)