francine
|
| Posted: 07/07/2003, 3:53 AM |
|
ASP access win2k
I want to have a mask for hour and minutes like this : HH:nn
I put this mask in :events :on load :on validate entry, but when I run ma
page I have instead the mask : HH:nn when I type a number.
If I put in the mask : 00:00 I can run my page and put number in the field
but what I want this is mask for hour and minutes
what to do ?
thank you
|
|
|
 |
DonB
|
| Posted: 07/07/2003, 4:40 PM |
|
You could try making the validation function:
Hours(yourfieldname) & ":" & Minute(yourfieldname)
Although I think that will truncate the leading zeroes. The FormatNumber
function will take care of that:
FormatNumber(yourfieldname,0,-1)
Not terribly elegant, I know.
DonB
"francine" <francine.gozman@dauphine.fr> wrote in message
news:bebjfq$q47$1@news.codecharge.com...
> ASP access win2k
>
>
> I want to have a mask for hour and minutes like this : HH:nn
>
> I put this mask in :events :on load :on validate entry, but when I run ma
> page I have instead the mask : HH:nn when I type a number.
>
> If I put in the mask : 00:00 I can run my page and put number in the field
>
> but what I want this is mask for hour and minutes
>
> what to do ?
>
> thank you
>
>
|
|
|
|
Sjg
|
| Posted: 07/12/2003, 2:51 AM |
|
Add an input field. Set the data type property to: Date.
Set the format Property to: Short Time.
The field will now need to be a valid time to pass the edits.
If the Database field to store the informatin is not a date field, make it
easy on yourself and make it a date field. No coding will need to be done
and this means less maintenance and easier to change the project to a
different language.
If it just cannot be a date field on the database. Do not link the input
field to the database. Put a hidden field for the time and in the on
validate, convert the time of the date field to the proper format and put it
in your hidden field. Use the date/time functins and string functns, etc...
to get it to the right format from there. The main thing is that the date
input field will have a valid time in the field.
Sjg
"francine" <francine.gozman@dauphine.fr> wrote in message
news:bebjfq$q47$1@news.codecharge.com...
> ASP access win2k
>
>
> I want to have a mask for hour and minutes like this : HH:nn
>
> I put this mask in :events :on load :on validate entry, but when I run ma
> page I have instead the mask : HH:nn when I type a number.
>
> If I put in the mask : 00:00 I can run my page and put number in the field
>
> but what I want this is mask for hour and minutes
>
> what to do ?
>
> thank you
>
>
|
|
|
|
|
