Cut off the word

[Guest]

In Control Source of the textbox in form I have =Format([txtweekday];"dddd").
Return, for example, Sunday word.
Is possible to cut off the Sunday word to Sun?

Thanks in advance.
an

 

[Stephen Lebans]

Change "dddd" to "ddd".
Did you copy and paste correctly? You need to have a comma char to seperate
the two arguments passed to the Format method.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

SL,
Thanks for your solution.
Work fine.
My paste is correct and work fine too...(?)

an

Change "dddd" to "ddd".
Did you copy and paste correctly? You need to have a comma char to seperate
the two arguments passed to the Format method.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

In Control Source of the textbox in form I have
=Format([txtweekday];"dddd").
Return, for example, Sunday word.
Is possible to cut off the Sunday word to Sun?

Thanks in advance.
an

 

[Dirk Goldgar]

SL,
Thanks for your solution.
Work fine.
My paste is correct and work fine too...(?)

The list separator -- "," vs. ";" -- is a regional setting, I think.

 

[Guest]

Exact.
I think too.
My regional setting use ";" and not ","

an

 

[Stephen Lebans]

Thanks Dirk
I need to get out of the country more often.
;-)

--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

Ok!
Cross the Atlântic and comes until Portugal
Certainly you will be well received.

an