|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 30th, 2006, 10:20 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Format property
Is there any way to specify an optional part of the format?
e.g. I want six digit numbers to format as 99.99.99 and I want 8 digit numbers to format as 99.99.99_99 I looked in Access help and could find no answer. 
|
|
#2
August 30th, 2006, 10:51 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Format property
The format property can't do this natively, but you could wrap your control
source in the format function and wrap that in an IIF function. Something like: IIF(Len([MyField])=6, Format([MyField],"99.99.99"), Format([MyField], "99.99.99_99") This is untested, but it might give you the idea. Barry "mscertified" wrote: Is there any way to specify an optional part of the format? e.g. I want six digit numbers to format as 99.99.99 and I want 8 digit numbers to format as 99.99.99_99 I looked in Access help and could find no answer.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
