Data Entry, VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Qyestions:

1 - In a memo field how to use enter key to go to the next line in the same field instead of going out of the field
2 - any adress that I can find the list of commands in VBA for access and the definitions and usage of the commands with examples
3 - how to use a formula in a field ( math. operation on one field and put the result in another field) (Micro or Procedure).
 
Use the Ctl + Enter Key.

1. If you use a TextBox Control on a Form, you can set the "Enter Key
Behaviour" Property so that you can use Enter in lieu of Ctl + Enter.

2. Access VB Help, look in the Contents.

3. If you are talking about DatasheetView of a Table, it is not possible.
It is intentional from Microsoft since you should NOT store calculated
values according to the Relational Database Design Theory.

If you use Forms for data entry, it is possible to write VBA code to do so
but think carefully before doing it because it violates the RDDT.

--
HTH
Van T. Dinh
MVP (Access)



Kz Pour said:
Qyestions:

1 - In a memo field how to use enter key to go to the next line in the
Click to expand...
same field instead of going out of the field?
2 - any adress that I can find the list of commands in VBA for access and
Click to expand...
the definitions and usage of the commands with examples.
3 - how to use a formula in a field ( math. operation on one field and put
Click to expand...
the result in another field) (Micro or Procedure).
 
Back
Top