Userfrom textbox .TextAlign issue

[demarc]

Hi there,

I have another small issue with a userform that I cannot seem to solve. I have a userform that opens in two different ways.

1. Initial opening the form is empty and you fill in all fields required. When you do this the .TextAlign center works correctly:

Userform.jpg

2. On other occasions the userform is pre filled with previously entered data on initialisation and this occurs:

userform1.jpg

When I click in the textbox on the userform the number in the textbox snaps back to center but initially, and without clicking in the box, the number is aligned to the right and partially obscured.

Its not a big issue but it is annoying and I cannot seem to correct the issue. All the relevant textboxes have TextAlign properties set to center:

Textalign.jpg

and I also run this code on initialisation of the userform:

Please Login or Register  to view this content.

Any suggestions on how to solve this one?

Cheers,
Marcus

[BadlySpelledBuoy]

Never seen a form do this before.

If there aren't many of them you could possibly solve it with a textbox change event that sets the alignment so when the control is populated.
That way it would all happen when you load the form with data already in.

BSB

[demarc]

Hi BSB,

Thanks for the reply, I tried adding a line to the change event but no joy. I did just solve my problem though by adding this to the code:

Please Login or Register  to view this content.

I do have lots of little issues with this program that I will be posting over the next week or two, what is the etiquette with asking lots of questions? Also if it is a more complex issue that is hard to explain with text and pictures is it possible to post a screen shot video of the problem?

Cheers,
Marcus

[BadlySpelledBuoy]

Nice fix.
Would like to see the form doing this though as I've never seen it happen before and I'm interested in what's causing it.

As for etiquette, feel free to ask all the questions you want. We're here to help. If there are a number of questions that are related to the same project then you can put them in a single thread. Obviously if you have many many questions then you may want to spread them out over a number of threads as overly long posts don't seem to attract much attention.

I don't think the forum has the functionality for posting videos I'm afraid.

BSB

[demarc]

Thanks BSB,

I placed the userform into a new workbook and commented out most of the code to it opens and closes, not sure if this will be usefull to you but feel free to have a look at the code. If you see anything that can be improved please let me know. I'm not much of a coder and when I started I never used Option Explicit but managed to get something together that worked.

Thanks for the response re etiquette, a single thread is probably a good idea for a few smaller issues and a individual threads for any larger issues.

Cheers,
Marcus

[BadlySpelledBuoy]

Under what circumstances does the form open pre-filled? That's the bit of code I'm interested in.


There is little point in me trawling through the 3k+ lines of code and pointing out bits that could be improved upon if it all works for you. A quick look through reveals no immediate concerns (unlike much of the VBA that comes my way in my work life! )

What's important in coding is that it works and is written in a way that means you will understand it when you come back to it in the future for bug fixing / amending.
We all have our own styles of writing code. Some people like to go for the smallest number of lines possible, some go for maximum efficiency. I go for plain simple code that will be understood by the people I ultimately hand the project over to meaning they can maintain them with little to no involvement from me.

BSB

[demarc]

The process is:

The form is used to enter information into a navigation log for a helicopter. Initially the log has not been created and when the userfrom first opens the user will enter all the information and then select the 'Create Navlogs' button which then creates the navlog. The process to creating a navlog is copying a blank navlog form and then entering all the information from the userform into it. Once you press the 'Create Navlogs' button all the information on the userform is also stored on a worksheet called 'Misc'.

Now when you have created your Navlog and you decide you want to change something on it there is a button on the form called 'Change'. When you press this button it opens the userform again and all the information from the 'Misc' worksheet is reloaded into the userform on initialisation. This is when the .TextAlign does not work correctly, only when you click in the textbox will it snap back to center.

Most of the code that does this is in the initialisation sub however I do have a module that has some code in it that is called that is not in the userform code.

There are a lot of moving parts in this program which makes it hard to nail down in one post.

Cheers,
Marucs