ACCESS FEED: RE: [MS_AccessPros] Attempting to place an input mask in a Control Source

Jumat, 25 November 2011

RE: [MS_AccessPros] Attempting to place an input mask in a Control Source

Thank you for steering me in the right direction Duane. I got it to work.

Have a great rest of the evening and a finer day tomorrow.

Sincerely,

David

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Friday, November 25, 2011 11:59 AM
To: ms_access_professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Attempting to place an input mask in a Control
Source

Use the Format() function.

Duane Hookom
MS MVP

To: MS_Access_Professionals@yahoogroups.com
From: drtolson@verizon.net
Date: Fri, 25 Nov 2011 09:07:22 -0500
Subject: [MS_AccessPros] Attempting to place an input mask in a Control
Source

Great Day, I have a Control Source for a text box in a report that I
am

attempting to place a numeric input mask in, but I get 0. Here is the

Control Source:

="Repair Order Number " & [JobID] & " for work performed on " &

[RepairDateIn] & ". Miles at time of service: " &

([RepairMilageIn].[InputMask]="#,###,###")

I am trying to place the comma separator in the number for thousands and

millions. Any assistance will be appreciated.

Thanks in advance,

David

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links