I need some help converting a date and number by using a custom format.
First, the Short date property in access doesn't give me what I'm looking for . I need the user to type in a date and have it be converted into July 26, 2004. So I need to convert 07/26/2004 into July 26, 2004. I am new to this so I might need a little hand holding.
Second. I need to convert a number using a custom format to include the thousand seperator. Exp, the user types 1234 and I need 1,234. I used the standard number property but the number won't carry the separator when I merge the value into word.