microsoft+access+training - masked text box

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training - Masked text box

microsoft+access+training - Masked text box

resolvedResolved · Low Priority · Version Standard

Simon has attended:
Access Advanced course

Masked text box

When you use a Mask on a Text Box for something like inputing a specific style e.g Upper Case , is it possible to get the curser to automaticaly start at the beggining of the Text Box when you click in it rather than were the click took place.

RE: Masked text box

Hi Simon

Yes this is possible. The settings for this may be in the properties for the text box, however if not you are able to code this functionality using either VB or VBA.

Hope this helps
David


 

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips


Server loaded in 0.11 secs.