Changing table field formats

[lmontes]

Hello

I'm adding fields to a table and am having problems setting the format for two of them.

1) Date/Time the format should be Long Time
2) Boolean the format should be Yes/No

I can set the field types, but not the formats? Is there a way to set these formats?

 

[LittleSmudge]

Why would you ever bother ?

No one is ever going to see them so who cases what format they are in.


What you need to do is set the format of the controls that you place on the forms and reports that the users see.

That is achieved using the text box control's Format property.


'ope-that-'elps.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.