Access: Key behavior in Field - Cursor

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,730
I have a filed on form that is formatted as currency with a default of zero "0". When the user enters the field to enter an amount, the cursor appears in front of the defaulted value of 0. So when they start entering a value - less say "17" it shows as $170 not $17. When they hit enter it enters $170.00

How do I fix this?

Thanks!
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,479
Office Version
365
Platform
Windows
Re: Access: Key behavior in Feild - Cursor

How about removing the default value, so then nothing appears initially?
 

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
811
Re: Access: Key behavior in Feild - Cursor

Try Googling for SelStart and SelLength
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
1,834
Re: Access: Key behavior in Feild - Cursor

this is an Access option in Client Settings (behavior entering field) as long as you're ok with it applying to all fields
 

Watch MrExcel Video

Forum statistics

Threads
1,100,107
Messages
5,472,515
Members
406,824
Latest member
Arun610235

This Week's Hot Topics

Top