custom data type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to make custom data type in access? I need to show the time
only

Octet32
 
To "show the time only", set the control format to a time format. You don't
need (and can't create) a custom data type.
 
Look at the date/time functions. In this case, the TimeValue function might
serve your needs.

Barry
 
Duane said:
To "show the time only", set the control format to a time format. You don't
need (and can't create) a custom data type.
Click to expand...

You can sort of achieve this with validation rules, more 'hybrid' than
'custom'.

The DATETIME data type allows time elements; to prevent the time
element, the validation rule could be:

HOUR(effective_date) = 0
AND MINUTE(effective_date) = 0
AND SECOND(effective_date) = 0

Merely not showing the time element could hide a problem; preventing
time elements would avoid such a problem.

Jamie.

--
 
Back
Top