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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/