Entering abbreivated time in fields

[Remel]

Hello,

I am searching for a way to enter time in an abbreviated format and having Access convert it to a standard time format. For example, I would like to enter "3p" and have the field convert that to "3:00 PM" after tabbing out of the field.

Can anyone help me with that? I would GREATLY appreciate any tips/ideas. Thanks in advance.

 

[jgoodman00]

I was thinking that perhaps you could split the leading integer values & the text suffix, & then concatenate the integer values with the number suffix (e.g 3 would become 3:00). You could then convert the text suffix into the correct time suffix (e.g p becomes p.m). Concatenating these could turn 3p into 3:00pm, but I am not sure how simple it will be to split the integer values from the text values. Perhaps someone else knows how this can be done, becuase it could prove most useful.... James Goodman
j.goodman00@btinternet.com

 

[Remel]

Thanks James. That is at least a start. I will give it a try and let you know how it comes out. If any others have ideas please post. I need all the help I can get.