I tried in all three possible form-views, and STATUS is not a text box but a simple field with text (no choice)
with design and layout view, I can see the button, and it is coloured but when I click/doublecklic...., nothing happens...
This sounds like a possible corruption issue?
If the button is coloured then clicking it should open the CF Rules manager.
It should only be available in form's design view, and you can also get to the CF option by right clicking on a textbox control when in design view.
Have you tried importing all the database objects into a new blank database?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Hi Brigitte, not quite sure I understand you here, forms don't have fields, they have controls and a text box is usually what is usually displaying a bound field from the form's record source. Are you sure you click the text box to select it (in design view) - if selected you should be able to see the borders witht the resizing handles in the corners. Labels, listboxes and ActiveX controls do not have conditional formatting.I tried in all three possible form-views, and STATUS is not a text box but a simple field with text (no choice)
with design and layout view, I can see the button, and it is coloured but when I click/doublecklic...., nothing happens...
Maybe you could post a screen shot with what you have.
Cheers,
Vlad
This sounds like a possible corruption issue?
If the button is coloured then clicking it should open the CF Rules manager.
It should only be available in form's design view, and you can also get to the CF option by right clicking on a textbox control when in design view.
Have you tried importing all the database objects into a new blank database?
TEST-Forum.mdb
yes I have imported different "old" Tables, forms, queries and reports to my new mdb
this also in the attached sample - in which I have now not added the dao 3.6 library (which I had in my original mdb when I started this thread)
and still, in whatever view I open the form "WEGLinks" the CF does not react at all
Interesting - here is your form opened in design view and the CF dialog.
I haven't done anything just opened it.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Here is my pic with 2007
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
This appears to be a very machine specific issue in light of the results in the previous 2 posts.
Have you tried to repair your office install on the problem machine?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
great, that is exactly what I would exspect to happen when I click the CF button, but it does not!!!!!!
and I really don't want to bother you with the maybe background library problems ... I can tell the form in my mdb what CF I want on my old PC and then just copy it back to my new PC :-) ... in - hopefully some months - I will not need any further "programming" and only use the mdb... thus my problem is sort of limited anyway :-)
guess so too:-)
a new installation is "in the pipe" talked to my sysadmin already, but they need my PC for a whole day... which is not possible at the moment ...
thus I'm really grateful that you want to help me out, but don't bother about that ... I found a - at least "preliminary" - solution and dont't want to occupy your brains with this specific stuff so much.... I just thought it was a simple "add a missing file and everything is ok" - matter...
I'll go on "programming" on my old PC for now, and be sure, I'll have more general problems of "how to make access do something ...." there :-)
have a good day and stay healthy!
lg
brigitte
Minty guesses that the fact that it doesn't work that way on my PC might be a problem with installation ... and he's probably right...
I'm really grateful that you want to help me, but don't bother!!! ... I found a - at least "preliminary" - solution and dont't want to occupy you for such specific stuff so much.... I'll go on "programming" on my old PC for now, and be sure, I'll need your help again for mor general problems!
have a good day and stay healthy!
lg
brigitte
I too, can get the CF dialog box. Out of curiosity, what happens if you open the attached dB using the PC that the sysadmin wants for a day?
Thank you so much - great - with your DB the - what I call fields - probably controls - it looks exactly what I want them to look like !!!!
but still the CF button does not react if I try to change that or - look at how you wrote the condition .....
SSAnfu-DB-Test.pdf
definitely seems to be a problem with my actual PC-installation !
You never did say if you tried a right click on the control and then chose Conditional Formatting?
Minty also asked you, I believe?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
THANK YOU so much for insisting!!!! - I did try that too, but probably in the wrong form view, as I then didn't find a CF-Option...
now that I learnt to try all 3 views, it really does work!!! (in what you seem to call design view)
you made my day! thank you so much!!!
CF - works with right click in Entwurfsansicht.pdf
So just to clarify completely - right click works, but the main CF button doesn't in Design View (Entwurfsansicht in German) ?
If so I would definitely say something is broken with the install!
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓