Macro Not displayed

[chad]

I have a small database. In it, I have a form set up so that when I enter a
score(number) in a certain text field (eg: 190+) a maco is set up to put the
same number in a number field, without the +(here it would be 190 without the
plus). This 190 number is added with another number for a total score
(obviously the 190+ in the text field cannot be the subject of addition.

When I enter the 190+ and move to the number field there is a solid black
bar,(the length of the number)the 190 is not shown. However when I close the
form and reopen it, the 190 is now displayed in the number field.

I have Access 2007 (which I don't like). When I enter the 190+ in the text
field, the 190 instantly appears in the subsequent number field.

Any way I can change 2002 so it would instantly display the number?

 

[Maurice]

Hi Chad,

Don't give up to soon on 2007. Show us what your macro is made up of so we
can try to mimic it and see what the problem is..

 

[Linq Adams via AccessMonster.com]

Private Sub TextField_AfterUpdate()
If Not IsNull(Me.TextField) Then
Me.NumberField = Val(Me.TextField)
Else
Me.NumberField = Null
End If

 

[chad]

Maurice, I don't like 2007 because when I open a form I have to take two
additional steps, not necessary in 2002: 1) I must minimize the Navigation
Pane so I can open and display the form in its full length 2) I must then
open the form to full form.

In 2002, I just open the form and it is opened to its full size.

2007 has the problem of the navigation pane lays over/on top of any form,
query, etc; whereas, in 2002, the form lays over/ontop of the (?) form list.

I am not that expert in this area, so how do I show you the macro on this
forum?

 

[chad]

Thanks for your time, but I am compeletely ignorant in the use of visual
basic, so don't know how to use your answer.

 

[Maurice]

Hi Chad,

You are correct about the nav.pane it can be a drag ;-)
No in regard to your macro. You have created a macro to perform the action
right? Describe the action you have created with the macro. In other words
describe the steps the macro takes to complete the task. Go to the nav.pane
click on your macro and choose design.

p.s. I assume that you have the macro's enabled in your project?

 

[chad]

I have 2 fields in a form 1) SatScore is a text field; 2) SatOpenScore is a
number field.

My macro is very simple: Condition: [SatScore]="180+"; Action: SetValue
Item: [SatOpenScore]; expression: "180".

When I enter 180+ in the field "SatScore" it should immediately enter 180 in
the field "SatOpenScore", as soon as I exit the "SatScore" field. Instead,
what it shows is a black bar approx the length of the 3 character number(if I
continue on to the next record and enter a score for the next person, no
mumber appears on the previous record until I close the form). If I then
close the form and reopen it, the 180 shows in the the "SatOpenScore" field.

When I use Access 2007 to open the same database and do the same entries as
above, the macro works correctly (as soon as I enter the 180+ in the
"SatScore field" and then exit that field, the 180 is displayed in the
"SatOpenScore" field.

 

[chad]

I forgot to mention, I then attach the macro, in the design mode, to the
property of the "SatScore" field.