Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Input Mask Does not Work As Expected in Access

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 01-02-2011
Member
 
Join Date: Jan 2011
Posts: 39
Input Mask Does not Work As Expected in Access
  

I am not an Access specialist; however I can make use of it quite fine. My trouble is that I have an HR database furthermore I would like to make use of an Input Mask intended for the last name field with the intention that the user will not have to make use of the upper case. Fine, certainly, the input mask is not superior for that since we have a lot of with two last names as well as suffixes furthermore the mask cannot address those circumstances. I have found some code on the way to address this which was specified out on the internet; however I do not know where to place it. Can you please assist me with this? Thanks a lot.

Reply With Quote
  #2  
Old 01-02-2011
Member
 
Join Date: Mar 2009
Posts: 1,360
Re: Input Mask Does not Work As Expected in Access

It is relevant to the table only if the table or else a query based on it are making used as the record source of the form. The On Current is a Form event as a result you require to click on the form's background on the way to get the form consequences or else open the form inside design mode. If Access cannot discover the object name you require to watchfully verifying the name of the Field you are attempting to work by. Can you tell me what is the name of your field on the form?
Reply With Quote
  #3  
Old 01-02-2011
Member
 
Join Date: Jan 2011
Posts: 39
Re: Input Mask Does not Work As Expected in Access

Thank you for your valuable suggestion. I have read someplace that the controls on the form did not apply to the table. I found On Current. I am trying to set the properties for the individual field in the form. I have entered the following: LastName = StrConv( LastName, vbProperCase).The field in the table is set up as Last Name. It illustrates as that in the fields in Queries, Forms as well as Reports. Do I require making a Function or else Macro first? At what time I click on Help in the Error Message I obtain this information:Access was not capable to position the macro or else VBA function. If you are attempting to call a macro, ensure that the name of the macro and the name of the macro collection are spelled appropriately.
Reply With Quote
  #4  
Old 01-02-2011
Member
 
Join Date: Nov 2008
Posts: 1,185
Re: Input Mask Does not Work As Expected in Access

If you indicate an Input Mask, after that you be supposed to extra input mask control characters on the way to inform Access what characters are allowable. Just having a ">" as an Input Mask will not function, for the reason that you have no characters permit input.If you are attempting to identify an Input Mask for Canadian, after that you may need the user to indicate the Country field primary (i.e., have the ZIP code field empty as well as locked until Country is detailed).
Reply With Quote
  #5  
Old 04-02-2011
Member
 
Join Date: May 2008
Posts: 979
Re: Input Mask Does not Work As Expected in Access

The code does not go inside the event line. The VBA code does not go in the Line which states event process, what you require to perform is Cut that portion of code as of from the event line. After that click the drop down as well as choose "Event Procedure", three small dots will come into sight on the right hand part, click on the dots furthermore it will open the VBA Editor at the Combo's "After Update" event process. You will need to make use of me.[EndName] = StrConv(me.[EndName], vbProperCase)
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Input Mask Does not Work As Expected in Access"
Thread Thread Starter Forum Replies Last Post
Unable to access HDMI input on Sony Vaio VGC-LV150J Faizah Portable Devices 8 17-10-2013 10:55 AM
unable to get the AUDIO LINE INPUT to work Dorkfoot Hardware Peripherals 4 04-09-2011 03:19 PM
How to get fierce deity mask on legend of zelda majoras mask bigboy Video Games 3 30-07-2009 10:13 PM
.PRN File Access Input Volodymyra Windows Software 2 27-10-2008 07:21 PM
Physical Address Extension (PAE) does not work on vista as expected. manishdk Windows Vista Performance 2 22-06-2008 11:33 PM


All times are GMT +5.5. The time now is 09:58 PM.