Search results

ok I got a temporary solution since I can't touch those fields in access with VBA since they are Bound fields I resorted to deleting the data in [CLEARED BY NM] that has data in the [REMARKS TX] field. It works but it almost defeats the purpose of what I am doing. So until I can find and IF...

So it only works on unbound fields. Ok i will keep trying to rig it but if it doesn't work It was worth a try thanks anyway for your help

Nope the fields value is still there and the actual field I wanted to change is [CLEARED BY NM] my mistake. The code runs with no compile error but nothing happens. I feel we are getting closer though Private Sub Report_Current() If IsNull(Me.[REMARKS TX]) Or Me.[REMARKS TX] = "" Then...

thanks I will give it a shot. i actually want it to display it as an empty field though :)

here is the revised code it runs with now errors but nothing happens Private Sub Report_Load() Dim AnyText As String If [REMARKS TX] = "AnyText" Then [IWC WC NM1] = Null End If End Sub It picked up the fields no problem with spaces but I think the null portion is not doing anything

If I go through and rename them without the spces should it work?

[remarks tx] and [iwc wc nm1] are text fields I know its a cardinal sin but it came from another database of which I had no control of the naming scheme.

Hi, As the user name states I am new at vba for access. I just need some help with a line or 2 of code let me display it first then explain what I need it to do Private Sub_Report_Open Dim AnyText As String If [Remarks TX] ="AnyText" Then [IWC WC NM1] = Null Else Cancel End If End Sub I...