making a string form various things

CrazyKillerMan

Registered User.
Local time
Today, 00:08
Joined
Nov 26, 2002
Messages
23
Hello

I was wondering the vb code to do something for me. I have a field that is ##_####
The first ## is the current week / 2
The '_' has to be placed in
and the last #### is the year.

ie: 23_2002

I want this as a default value for a field on the form. So AfterUpdate on a list box, it will automatically put in this string of text. How does one combine these values?

I beleve in c++ its syntax is:
value_forstring = week/2 . "_" . year
 
I think your looking for &[/&]

Code:
week/2 & "_" & year
 
yep - that does it

thanky
 

Users who are viewing this thread

Back
Top Bottom