Input Mask - quick question
in [Form]
|
Prev: What is the extra field added with a combo or list box
Next: Reminder - Microsoft Responds to the Evolution of Community
From: prodata on 20 May 2010 10:43 Sorry I'm just an occasional Access user but need to tweak an existing form in a database. This has a couple of fields for holding latitude and longitude values, which we need to store as text values in deg:min:sec format, eg 12:34:56 . (When I say 'store' I mean that literally. The database file is accessed by a completely separate custom VB program that reads these two fields as strings and expects to see two colon characters in each field string in the appropriate places.) I'd been hoping to use an input mask so that users don't forget to enter the colons, which they're apt to do. In other words, so that all the user needs to do is to enter only the digits, with the colons effectively being entered automatically For the input mask I've tried using 00:00:00 and then 00\:00\:00 (wondering if the colons needed to be a literal) but in neither case do the colons seem to get stored in the relevant database fields. Anyone able to advise please?
From: Douglas J. Steele on 20 May 2010 11:17 Read about the (optional) second section in the Help file (or see http://msdn.microsoft.com/en-us/library/bb215691.aspx ) -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "prodata" <gprodata(a)googlemail.com> wrote in message news:b38ed250-aada-46f0-83c1-8670d24a763c(a)c11g2000vbe.googlegroups.com... > Sorry I'm just an occasional Access user but need to tweak an existing > form in a database. This has a couple of fields for holding latitude > and longitude values, which we need to store as text values in > deg:min:sec format, eg 12:34:56 . > > (When I say 'store' I mean that literally. The database file is > accessed by a completely separate custom VB program that reads these > two fields as strings and expects to see two colon characters in each > field string in the appropriate places.) > > I'd been hoping to use an input mask so that users don't forget to > enter the colons, which they're apt to do. In other words, so that all > the user needs to do is to enter only the digits, with the colons > effectively being entered automatically > > For the input mask I've tried using 00:00:00 and then 00\:00\:00 > (wondering if the colons needed to be a literal) but in neither case > do the colons seem to get stored in the relevant database fields. > > Anyone able to advise please?
From: prodata on 20 May 2010 12:20 On May 20, 4:17 pm, "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote: > Read about the (optional) second section in the Help file (or seehttp://msdn.microsoft.com/en-us/library/bb215691.aspx) > Thanks - that suggests that simply adding a semicolon and a zero to the end of my input mask should do the trick. But sadly it doesn't seem to. So, if I set the input mask to 00:00:00;0 (penultimate character is a semicolon) then 12:34:56 is still stored just as 123456 . Using 00\:00\:00;0 gives no improvement. What am I missing? Does the input mask need to be in quotes? Should there be a space in there after the semicolon, or an additional terminating semicolon? Or what?
From: Douglas J. Steele on 20 May 2010 12:56 Do you have the field set to Text, not a number? -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "prodata" <gprodata(a)googlemail.com> wrote in message news:dce8fc1e-d9af-4604-b4fd-0ab40521ea21(a)q23g2000vba.googlegroups.com... On May 20, 4:17 pm, "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote: > Read about the (optional) second section in the Help file (or > seehttp://msdn.microsoft.com/en-us/library/bb215691.aspx) > Thanks - that suggests that simply adding a semicolon and a zero to the end of my input mask should do the trick. But sadly it doesn't seem to. So, if I set the input mask to 00:00:00;0 (penultimate character is a semicolon) then 12:34:56 is still stored just as 123456 . Using 00\:00\:00;0 gives no improvement. What am I missing? Does the input mask need to be in quotes? Should there be a space in there after the semicolon, or an additional terminating semicolon? Or what?
From: prodata on 20 May 2010 13:03
On May 20, 5:56 pm, "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote: > Do you have the field set to Text, not a number? Yes, definitely text. |